topic loading multiple excel files in QlikView

loading multiple excel files

david_ze — Mon, 26 Jan 2026 18:19:17 GMT

Hi All, I'm loading mutiple excel files with the same tables by using the script below:

For each ExcelFile in filelist ('*.xls')

My_data:

Load * From $(ExcelFile) (biff, embedded labels, header is 1 lines, table is Sheet1$);

Next ExcelFile;

The result of the reload is that Qlikview creates synthetic keys for each filed multiple by the number of files.
I'll appreciate your advice on how to avoid the synthetic keys.
Regards
David

loading multiple excel files

Jason_Michaelides — Thu, 15 Sep 2011 21:19:12 GMT

Assuming all files are the same and that each file only contains one of each field name (ie no duplicate field names) then:

My_Data:

LOAD

FROM C:\<path>\*xls...;

That should work.

Hope this helps,

Jason

loading multiple excel files

danielrozental — Thu, 15 Sep 2011 23:07:15 GMT

Try something like

My_data:

Load null() as somefield

autogenerate(0);

For each ExcelFile in filelist ('*.xls')

concatenate(My_data)

Load * From $(ExcelFile) (biff, embedded labels, header is 1 lines, table is Sheet1$);

Next ExcelFile;

drop field somefield;

loading multiple excel files

david_ze — Fri, 16 Sep 2011 05:25:06 GMT

Thanks Daniel it works fine...
David