Error In Script?

[Anonymous]

Hi All,

QVD's are not being generated for few tables with the below script.

Ex: I have following tables

Table_2014,

Table_2014_1,

Table_2015_2,

Table_2015_6 ..of these.. only few tables are getting stored to qvd's sometimes the 1st and 3rd gets loaded, and sometimes 2nd and 3rd table, but not all the tables.

this is wat i have written....

FOR i=0 to NoOfTables()-1

LET vTabName=TableName(0);

STORE [$(vTabName)] into \\QVDpath\$(vTabName).qvd (qvd);

DROP Table [$(vTabName)];

NEXT i

Is there any problem with tables naming convention...

John

[jonas_rezende]

johnlewis‌

What is the error message?

[Anonymous]

error in store command...

[jonas_rezende]

Please, post your  QVDPath as initialized variable, including, just like the line STORE and INTO.

[sasiparupudi1]

your problem is with the drop table statement which is altering the count of NoOfTables() after each drop so your vTabname is getting null value in the loop

FOR i=0 to NoOfTables()-1

LET vTabName=TableName($(i));

STORE [$(vTabName)] into \\QVDpath\$(vTabName).qvd (qvd);

DROP Table [$(vTabName)];-----> remove it

NEXT i

HTH

Sasi

[sasiparupudi1]

you could use the following script for dropping the tables

   do while NoofTables()>0

     LET vTabName = TableName(0);

     DROP TABLE $(vTabName);

     loop;

[sasiparupudi1]

Hi

Have you managed to solve your problem?

Sasi

[qlikviewwizard]

‌hi ,

please select the correct, helpful answers and close the thread.

thank you.

[Anonymous]

Thanks Sasi, appreciate your suggestions and thanks qlik community for bringing wonderful people on to single platform.