Load qvd based on the variable value

[#1]

Can we load the Qvds for the value in the variable.

for eg: There is a loop where the i value changes and i need the previuos file to be loaded everytime, like my from statement which is as below

FROM "D:\Working\Max"&$(i)-1&".qvd" (qvd);

[#2]

Yes, you can use variable in QVD name. to only change you must done to the exemple string to work is "D:\Working\Max"&num($(i)-1)&".qvd" (qvd);

[#3]

Yes, it possible. It goes something like this:

For <>
SET vQvdPath = 'D:\Working\Max'&$(i)-1&'.qvd(qvd)';
Data:
Load * from $(vQvdPath);

Next