hi guys, how can i load dynamically xlsx files into same folder and concatenate tables? table for each xlsx have the same name
If all files have the same structure you can load them with asterisks in the path
[Table]: LOAD * From [C:\QlikView\ *.xlsx] (ooxml, embedded labels, table is Sheet1);
Retrieving data ...