Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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..

Highlighted
MVP
MVP

add a space

LOAD * Inline[

LOAD * Inline [

Not applicable

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