topic Re: Read Multiple Excel files and concatenate in one file in QlikView

Read Multiple Excel files and concatenate in one file

mario-sarkis — Sat, 16 Nov 2024 21:29:24 GMT

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 — Fri, 01 Feb 2019 09:33:15 GMT

anriretief — Fri, 01 Feb 2019 10:12:43 GMT

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];