Hi all 🙂
I'm trying to save multiple QVDs in different folders. I tried the code below, but is does not work since, I could not figure out how increment the value of variable 'x' to save the QVD in the right folder. Any idea? thanks 🙂
Let i=2300;
For each vGBU in 'YCA1S001', 'YCA1S012', 'YCA1S014'
Let x=$(i)+100;
CrossTable (Measure, Value, 3)
$(vGBU)_Facts_SalesCluster:
LOAD
//qualifying columns
Customer_Sold_To,
Period,
Year
//Measures
NPM_Total_Sales,
Product_Sales,
FROM [lib://Stream_0100_QStorage/20_Transform/Facts_GMD.qvd]
(qvd)
WHERE YGBU ='$(vGBU)'
STORE '$(vGBU)_Facts_SalesCluster' INTO [lib://Stream_$(x)_QStorage\50_Testdata\$(vGBU)_Facts_SalesCluster.qvd] (qvd);
Drop table '$(vGBU)_Facts_SalesCluster';
Next ;
