Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading

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?

1 Solution

Accepted Solutions
Colin-Albert

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.



View solution in original post

3 Replies
Colin-Albert

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
Specialist III
Specialist III

May be this:

FinalData:

LOAD *

FROM customer_*10.QVD(qvd);


Regards!

Rahul Pawar

Anonymous
Not applicable
Author

Thank you so much!! Worked like a charm