Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i am working on a task to improve the current load script for easy readability
we are loading the last 3 financial year files the files are named as follows
eg: Filename_year_2021
Let vFinPayCurrent = $(vMfinyr)&$(vMfinyr)+1; //Current Finpay
Let vFinPayLastYear = $(vMfinyr)-1&$(vMfinyr); //Last financial year
Let vFinPay2YrsAgo = $(vMfinyr)-2&$(vMfinyr)-1; //2 Financial Years ago
For loop to concat all these together,
Set vfilelist ='vFinPayCurrent','vFinPayLastYear','vFinPay2YrsAgo';
for each var in vfilelist
MyTable:
load *
FROM [$(vG.QVDPath)/Filename_year_$(var).qvd]
Next var
CURRENT Approach:
mytable:
load * from
[$(vG.QVDPath)/Filename_year_$(vFinPayCurrent ).qvd]
concatenate
load * from
[$(vG.QVDPath)/Filename_year_$(vFinPayLastYear ).qvd]
concatenate
load * from
[$(vG.QVDPath)/Filename_year_$(vFinPay2YrsAgo ).qvd]
Thanks in advance
can you see in your variable section about output what is there for these 2 variables? (var, vfilelist )