Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
linxili10
New Contributor II

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

Re: Loading

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

Re: Loading

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

rahulpawarb
Valued Contributor III

Re: Loading

May be this:

FinalData:

LOAD *

FROM customer_*10.QVD(qvd);


Regards!

Rahul Pawar

linxili10
New Contributor II

Re: Loading

Thank you so much!! Worked like a charm