How to create multiple QVD's

tahreen371 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

can anyone help me with the script for creating multiple QVD's with the Loop:

Please refer the below script and guide me on what needs to be corrected, as this script do not generate any QVD in location given:

Names:

Peter1:

LOAD * INLINE
[ Region, Year, Month, Sales
South, 2014, June, 645
North, 2014, May, 245
North, 2014, May, 347
];

FOR vCount=0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

STORE $(vTableName) INTO [C:\Users\Naveen A\Desktop\Excel.qvd](qvd);

NEXT vCount;

Re: How to create multiple QVD's

Somasundaram — Mon, 18 Feb 2019 11:53:59 GMT

HI,

STORE $(vTableName) INTO [C:\Users\Naveen A\Desktop\ $(vTableName).qvd](qvd);

just change the above line. It's working perfectly.