topic Re: Loading in QlikView

Loading

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Loading

Colin-Albert — Wed, 16 Aug 2017 10:22:41 GMT

No need to create a loop

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

LET vDay = 10;

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

Will load all the files that match the wildcard.

Re: Loading

rahulpawarb — Wed, 16 Aug 2017 10:38:19 GMT

May be this:

FinalData:

LOAD *

FROM customer_*10.QVD(qvd);

Regards!

Rahul Pawar

Re: Loading

Anonymous — Wed, 16 Aug 2017 11:55:46 GMT

Thank you so much!! Worked like a charm