Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion
Partner - Champion

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
Partner - Champion
Partner - Champion

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