Loading excel files from several directories

david_ze — Sat, 01 Oct 2011 17:15:07 GMT

hi all,

Will appreciate your help and advice...

I'm loading all excel files located in directory 'c:\temp', using the below code:

Directory C:\temp\
set filectr=0;
For each ExcelFile in filelist ('*.xls')
If filectr=0 then
temp_xls_files:
Load Date1 as sign_date,
cellnum,
cust_name
from $(ExcelFile) (biff, embedded labels, header is 1 lines, table is Sheet1$);
Else
temp_xls_files:
Concatenate
Load Date1 as sign_date,
cellnum,
cust_name
from $(ExcelFile) (biff, embedded labels, header is 1 lines, table is Sheet1$);
EndIf
Let filectr=$(filectr)+1;
next ExcelFile

now, I would like to load more files (in the same format) but from additional directory - c:\temp1.
when I'm duplicating the code to load from c:\temp1, QV creats Synthetic keys for each field.

My question is, how can i use the above code to load all excel files from several directories ?

Thanks in advanced.
David

Re: Loading excel files from several directories

Sat, 01 Oct 2011 18:16:26 GMT

Hello David,

I hope you are not using the if part for the second directory. Just concatenate is enough.

Regards,

Kiran.

Loading excel files from several directories

david_ze — Sat, 01 Oct 2011 19:06:12 GMT

You're right...I've eliminated the if and it works ok.
Thanks Kiran for your advise,
David

topic Loading excel files from several directories in QlikView

Loading excel files from several directories

Re: Loading excel files from several directories

Loading excel files from several directories