Store 1, Product 1, New Store 1, Product 2, Used Store 1, Product 3, Used Store 2, Product 1, Used Store 2, Product 2, New Store 3, Product 3, New
I would like to display this data on three pages:
FIRST PAGE: Store 1 Table: Product 1, New Product 2, Used Product 3, Used
SECOND PAGE: Store 2 Table: Product 1, New Product 2, Used Product 3, Used
THIRD PAGE: All Locations Store 1, Product 1, New Store 1, Product 2, Used Store 1, Product 3, Used Store 2, Product 1, Used Store 2, Product 2, New Store 3, Product 3, New
If you want to use the Excel file as a data source, you would need to create these three tables separately.
On the other hand, if you have all this data stored in the database, you could use SQL Query based table to pull the data from a single database table in three different wpDataTables using different queries.
Is it possible to have multiple views of the same single table? For example, I have an Excel file with the following data:
Master inventory table (STORE NAME, PRODUCT NAME, STATUS)
Store 1, Product 1, New
Store 1, Product 2, Used
Store 1, Product 3, Used
Store 2, Product 1, Used
Store 2, Product 2, New
Store 3, Product 3, New
I would like to display this data on three pages:
FIRST PAGE: Store 1
Table:
Product 1, New
Product 2, Used
Product 3, Used
SECOND PAGE: Store 2
Table:
Product 1, New
Product 2, Used
Product 3, Used
THIRD PAGE: All Locations
Store 1, Product 1, New
Store 1, Product 2, Used
Store 1, Product 3, Used
Store 2, Product 1, Used
Store 2, Product 2, New
Store 3, Product 3, New
Hello Chris.
If you want to use the Excel file as a data source, you would need to create these three tables separately.
On the other hand, if you have all this data stored in the database, you could use SQL Query based table to pull the data from a single database table in three different wpDataTables using different queries.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables