How to set a variable in Load Editor to take into account a range of dates

[DamianoD]

Hi folks,

I have coded a script as following:

let vNumMonthRolling = 36;


for a = 0 to $(vNumMonthRolling);


LET vYearMonthtoLoad = Date(AddMonths(Today(),-$(a)),'YYYY_MM');

Review:
LOAD *
FROM $(vs_QVD_Store_Path)Review Acq Rm_'$(vYearMonthtoLoad)'.qvd
(qvd);

next a;

It works perfectly, since I got QVD's Part from 2020_09 to 2023_09, the problem is that I also would like to take into consideration QVD's part from 202310 to 202409 (One Year on from now, excluding 2023_09 already taken from the first variable).

Is there a way to put it in the same variable, as well as concatenating it into the same table with another piece of coding?

Thanks,

D

[Or]

You should just need to run the exact same code but for vMonthRolling = 48 and add -$(a)+12, I think?