topic for loop or do while in QlikView

for loop or do while

Mon, 22 Mar 2010 15:23:55 GMT

Hi Gurus,

I have one csv files for each day like exportfile-2010-01-01.csv . Starting for 01/01/2010 .. i am able to load the today file using

Datafile:

Load ...

.......

FROM
.

Store datafile into C:\QlikView\DevelopmentDocuments\QVD Files\exportfile_$(vtoday).qvd

so it generates one qvd file each day.

but i want generate the backdate files ( starting from 01/01/2010 to 21/03/2010) using loop condition.

Could you please tell me how it can be done in qlikview.

for loop or do while

Mon, 22 Mar 2010 15:38:07 GMT

Try something like this (parts borrowed from a Calender creation script)


LET vDateMin = Num(MakeDate(2010,1,1));
LET vDateMax = Num(Today());

// Autoload data files
TempTable:
LOAD *,
 Date($(vDateMin),'YYYY-MM-DD') AS LoadDate
FROM exportfile-Date($(vDateMin),'YYYY-MM-DD').csv (csv)
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

It should concatenate all the date csv-files from 2010-01-01 till today.

Not sure if it still works when a file is missing (like if you don't generate a csv-file on sundays).

for loop or do while

Mon, 22 Mar 2010 16:18:50 GMT

Hi Mark,

It is just loading only 01/01/2010 file.

for loop or do while

Mon, 22 Mar 2010 18:37:10 GMT

This should work better 😉


LET vDateMin = Num(MakeDate(2010,1,1));
LET vDateMax = Num(Today());

FOR a=$(vDateMin)

DO WHILE a <= $(vDateMax)

TempTable:
LOAD *,
 Date(a,'YYYY-MM-DD') AS LoadDate
FROM exportfile-Date(a,'YYYY-MM-DD').csv (csv);

LET a=a+1;

LOOP