Discussion board where members can get started with QlikView.
I have two types of excel files in two folders.
EMP_SAL_Timestamp.xls in C\EMP_SAL folder
DEPT_SAL_Timestamp.xls in C\DEPT_SAL folder
How to load these N no of xls files into Qlikview?
Thanks in advance.
LOAD * INLINE [
Load multiple excel files from Multiple excel sheetsinto QV
See thsi example to LOAD all excel & all sheets
If all the files having the same number of columns and having the same sheet name then you can simply load by * in file name
For each group of files you can use:
FOR Each Dir in DirList ('$(Root)\'&'*.')
FOR Each File in FileList ('$(Dir)'&'\EMP_SAL*.xlsx')
FROM [$(File)] ....
You can simply write two load statements with wildcards in filename like below, don't make the script complicated by using For loops if you have only two file paths.
Hope this helps you.