topic Re: Loading multiple excel files by incrementing the months in QlikView

Loading multiple excel files by incrementing the months

Anonymous — Fri, 22 Apr 2016 09:50:20 GMT

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 — Fri, 22 Apr 2016 09:52:47 GMT

May be like this:

LOAD

FROM

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

or check these links:

Anonymous — Fri, 22 Apr 2016 09:55:00 GMT

I need this to be incremented till 2016

sunny_talwar — Fri, 22 Apr 2016 09:56:15 GMT

Then may be this:

LOAD

FROM

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

Anonymous — Fri, 22 Apr 2016 10:38:54 GMT

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 — Fri, 22 Apr 2016 10:40:22 GMT

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 — Fri, 22 Apr 2016 10:46:51 GMT

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