I'm trying to load all the excel files from a folder into Qlik Sense.
Weekly wise excel files are add to that folder so i want to load them.
Solved! Go to Solution.
Hello Bill Markham,
i tried it already it's loading only one file from the folder.
i'm looking something like for loop method to load all the excel files
Dear Bill Markham,
actually the sheet-name in some excel files are sheet1 and in some files it's salesdata and
other than this some of the excel files format is different that why it's not reloading all the files.
FROM [lib://Excel Files Data (Mukram/*.xlsx]
(ooxml, embedded labels, table is Sheet1);