Skip to main content
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