// 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
