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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how create number of qvds at a time in qlikview

Hi Friends,

please chech\k below image and code.

LOAD * Inline[

             TableName

             CustomerLegar

             DimAccount

             DimCustomer

             DimEmployee

             DimProduct

             DimProductCategory

            

];

for i = 1 to FieldValueCount('TableName')

let Vtable = FieldValue('TableName',i);

select  * from $(Vtable);

store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd(qvd);

Next

Error.png

3 Replies
MK_QSL
MVP
MVP

may be try below

for i = 1 to FieldValueCount('TableName')

let Vtable = FieldValue('TableName','$(i)');

select  * from $(Vtable);

store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd(qvd);

Next

EDIT:
I think we are missing the extension of the file we are going to load first..

maxgro
MVP
MVP

add a space

LOAD * Inline[

LOAD * Inline [

Not applicable
Author

Try following code.

You forgot to add LOAD before SQL

for i = 1 to FieldValueCount('TableName')

let Vtable = FieldValue('TableName','$(i)');

    $(vTable):

            LOAD

            *

        ;

        SQL select * from $(vTable)

        ;

store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd;

DROP TABLE $(vTable);

NEXT