Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I need to load multiple excel files . The files are named exactly the same with the only difference being that the month is incremented. eg.
H2H and FLU Low Level MI - Mar 2015.xlsx..So for subsequent months it becomes the following and so on till 2016 April.
H2H and FLU Low Level MI - Apr 2015.xlsx'
H2H and FLU Low Level MI - May 2015.xlsx'
H2H and FLU Low Level MI - Jun 2015.xlsx'
Is there a way to use a loop and increment the months it make it easier?
May be like this:
LOAD
FROM
[H2H and FLU Low Level MI - * 2015.xlsx];
or check these links:
QlikView - Loading Data From Multiple Files - YouTube
How to load multiple xls files in script
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
I need this to be incremented till 2016
Then may be this:
LOAD
FROM
[H2H and FLU Low Level MI - *.xlsx];
Thanks Sunny. This worked but for some reason it has not picked up the April 2015 and March 2016 is not getting picked . would you know the reasons ?
Difficult to say, but you can try this. Also make sure File Type is XSLX
LOAD
FROM
[H2H and FLU Low Level MI*.xlsx];
Thanks Sunny. It worked as some of it were xls. I have changed the file formats..