Qlik Sense Loop through multiple excel documents and sheets

DataWhisperer — Thu, 12 Aug 2021 11:36:09 GMT

Good Day,

I have multiple excel documents which I am trying to import into Qlik Sense, the files are such as the following,

StockAudit_2021.04

StockAudit_2021.05

StockAudit_2021.06

Each of these excel documents has the same structure, there are multiple sheets with only 2 columns present - 001 and Second Hand on each sheet.

I am trying to create code to cycle through these files and check for new ones and then add that file along with all that files sheets into the model.

Any ideas on how to run this in Qlik sense?

Re: Qlik Sense Loop through multiple excel documents and sheets

Taoufiq_Zarra — Thu, 12 Aug 2021 12:32:38 GMT

@DataWhisperer

I recommend to study the code in the link

https://community.qlik.com/t5/QlikView-Documents/Load-Multiple-excel-sheets-using-For-loop/ta-p/1489513

topic Re: Qlik Sense Loop through multiple excel documents and sheets in App Development

Qlik Sense Loop through multiple excel documents and sheets

Re: Qlik Sense Loop through multiple excel documents and sheets