Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tahreen371
Contributor III
Contributor III

How to create multiple QVD's

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;

1 Reply
Somasundaram
Creator III
Creator III

HI,

 

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

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


-Somasundaram

If this resolves your Query please like and accept this as an answer.