Do while loop

HamJan — Thu, 25 May 2023 10:59:53 GMT

Hi.

I am trying to load data from multiple qvd:s and then save it like

LET Start = AddMonths(makedate(year(Today()), 1, 1),0);

LET End = AddMonths(makedate(year(Today()), 12, 31),0);

do while Start <= End

let YearMM = Year(date('$(Start)','YYYY-MM-DD'))*100+Month(date('$(Start)','YYYY-MM-DD'));

NoConcatenate

TMP:

LOAD

Field1,

Field2,

Field3

from [path/File_$(YearMM).qvd]

(qvd);

left Join(TMP)

Load

Field1,

Field2

FROM [Path/file2.qvd]

(qvd);

left join(TMP)

load distinct

Field1

max(YearMM) as YearMM,

1 as MaxYearMM

resident TMP

group by Field1;

NoConcatenate

EndTable:

load

resident TMP

where MaxYearMM=1;

Drop Table TMP;

LET Start = date(AddMonths('$(Start)',1),'YYYY-MM-DD');

LOOP

store EndTable into [Path/endfile.qvd] (qvd);

But i can not get the loop logic to work so at the end it would go correctly. Any tips how to fix?

topic Do while loop in App Development