I would like to know if it's possible to use an Excel sheet as table but also combine it with another table (Excel or database).
The Excel sheet is an export from a program and I would like to import it directly into Wordpress/WpDatatables without any adjustments. But I would like to show some additional information coming from another table or source and display the result for example as in the popup from Master detail tables.
For you to combine these tables into one, you would need to either create a third Excel file combining these tables and then importing it or import the Excel file, so the tables are manual tables, stored in the database. Then, you would be able to use SQL query based tables to merge them together.
Please note that writing custom queries is not included in the provided support for the plugin, so we wouldn't be able to help you with that.
I would like to know if it's possible to use an Excel sheet as table but also combine it with another table (Excel or database).
The Excel sheet is an export from a program and I would like to import it directly into Wordpress/WpDatatables without any adjustments. But I would like to show some additional information coming from another table or source and display the result for example as in the popup from Master detail tables.
Hope there's a workaround for this.
Hi Simon
Thank you for reaching out to us.
For you to combine these tables into one, you would need to either create a third Excel file combining these tables and then importing it or import the Excel file, so the tables are manual tables, stored in the database. Then, you would be able to use SQL query based tables to merge them together.
Please note that writing custom queries is not included in the provided support for the plugin, so we wouldn't be able to help you with that.