Sorry, been busy lately. I'll do my best.
12 months: yes you can change that. I didn't define a variable for the number of months you want to go bback because you stated that the final document will only load data from the last 12 months. Change the FOR loop start into something like:
SET vNumOfMonthsToGoBack = 24; // Now we get a run for 24 (preceding) months
FOR j = 0 TO $(vNumOfMonthsToGoBack) - 1
:
File naming: the LET statement in the FOR body assigns a different name to each successive table. If I understand it correctly, you can modify the LET statement into something like. This. Note that if you want to cover more than 12 months, you should include the year as well. That's what this LET statement does.
LET TableName = 'RE0001-$(=year(AddMonths(today(), $(j))))$(=num(Month(AddMonths(today(), $(j))), '00'))';
Resident source data: just to make my example code simpler. The LOAD is from a central RESIDENT table that contains all data. YMMV. BTW Your assumption about how it operates is correct.
Code comment 2: exactly, that's all there is to it. You create a QVD if one of these conditions is met:
- For Current month (j = 0) =: always
- For Previous month (j=1 and day = 1) = only on the first of the current month
- For missing QVD = always. This is the big initial load.
Best,
Peter
