// List all files in the Sales Report folder SalesReportFiles: LOAD FileName() as FileName FROM [lib://APAC D&A - Data Connections:APAC_D&A_APACDA_QlikFlatfiles_PROD/Shared Documents/Prod Projects/Plannining And Fin] (txt, codepage is 1252, no labels, delimiter is '\t', msq);
// Loop through the files and load data from each file for each vFile in FieldValueList('FileName') // Load data from each file into the Fact1 table //Concatenate( [Fact_His_temp]) Fact1: LOAD *
FROM [lib://APAC D&A - Data Connections:APAC_D&A_APACDA_QlikFlatfiles_PROD/Shared Documents/Prod Projects/Plannining And Fin/$(vFile)] (ooxml, embedded labels, table is AZ);
i created these but it only take data from 1 sheet of all files i want it take data from all sheets which is present in files
