Loading multiple excel files by incrementing the months

[Anonymous]

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?

[sunny_talwar]

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

[Anonymous]

I need this to be incremented till 2016

[sunny_talwar · Accepted solution]

Then may be this:

LOAD

FROM

[H2H and FLU Low Level MI - *.xlsx];

[Anonymous]

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 ?

[sunny_talwar]

Difficult to say, but you can try this. Also make sure File Type is XSLX

LOAD

FROM

[H2H and FLU Low Level MI*.xlsx];

[Anonymous]

Thanks Sunny. It worked as some of it were xls. I have changed the file formats..