Loading

[Anonymous]

I have created a job that creates table every day, stored into a folder on the qlikview server on the format FileName_YYYYMMDD. I now want to create a job that loads all the files "customer_YYYYMM10", so I can create a report where I compare the monthly development.

I tried something like this:

LET vMonthYear = Date(Today(),'YYYYMM');

LET vMonth = NUM(IF(Day(Today())>10,Month(Today()),Month(Today())-1),'00');

LET vDay = 10;

Do while vMonthYear < Today()

LOAD * from E:\Qlik\customer_vMonthYear$(vDay).qvd (qvd);

Let vMonth=vMonth+1;

Loop

However, this doesnt work.. Can anyone please help me with this?

[Colin-Albert · Accepted solution]

No need to create a loop

LOAD * from E:\Qlik\customer_*.qvd (qvd);

or

LET vDay = 10;

LOAD * from E:\Qlik\customer_*$(vDay).qvd (qvd);

Will load all the files that match the wildcard.

[rahulpawarb]

May be this:

FinalData:

LOAD *

FROM customer_*10.QVD(qvd);

Regards!

Rahul Pawar

[Anonymous]

Thank you so much!! Worked like a charm