Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
LOAD * inline [
"First name"|"Last name"|Initials|"Has cellphone"
John|Anderson|JA|Ye
Sue|Brown|SB|Yes
Mark|Carr|MC |No
] (delimiter is '|');
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;
HI,
STORE $(vTableName) INTO [C:\Users\Naveen A\Desktop\ $(vTableName).qvd](qvd);
just change the above line. It's working perfectly.