topic Re: Adding multiple excel files in QlikView

Adding multiple excel files

Wed, 25 Nov 2020 16:16:04 GMT

Ok guys, so I have a folder with many excel files. All of them start the same way.I added one of them and created a chart as I want it.Now I want to add all the other files and doing it manually is not an option. After Loading the first one,can I add the others like that ?

LOAD *

From

(biff, embedded labels, table is [справка №2-ОТЧЕТ ЗА ДОХОДИТЕ$]

Re: Adding multiple excel files

Anonymous — Thu, 10 Mar 2016 16:55:28 GMT

If all the columns are the same in all of the files, then load * should work. If they have different sheet names in the excel files, just take out ", table is [справка №2-ОТЧЕТ ЗА ДОХОДИТЕ$]" from the last line.

Re: Adding multiple excel files

santiago_respane — Thu, 10 Mar 2016 20:51:03 GMT

Hi Dilyan,

You can use a For to loop through files, this way when there are no files to load you wont get an error.

Something like this:

FOR Each File in filelist ('C:\Users\dilyan\Desktop\Reports\*.xls')

LOAD *
FROM ['$(File)'] (biff, embedded labels, table is [справка №2-ОТЧЕТ ЗА ДОХОДИТЕ$];

NEXT File;

Hope this helps.

Kind regards,

Re: Adding multiple excel files

Thu, 10 Mar 2016 21:09:20 GMT

Hi Santiago,

I don't get an error message when I execute it the way you mention but I don't have my fields anymore available. I only have ....