Read Multiple Excel files and concatenate in one file

[mario-sarkis]

Dear all,

I have multiple excel files I should read and concatenate together:

For example :

first excel File Name is : KANARI_20190129      (YYYYMMDD)

second excel file is : KANARI_20190130

third Excel : KANARI_20190202

......

is there is a loop for this?

hope you can help

Thanks

[pradosh_thakur]

Have a look

https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-wit...

https://community.qlik.com/t5/QlikView-App-Development/loop-through-to-load-all-files-from-a-folder-...

[anriretief · Accepted solution]

I the Excel files are all in the same folder you can just do the following

at the end of the table loaded just add * to the file name where the date is

load

......

from

[file path/KANARI*.xls];