Generic script to delete all tables

[OmarBenSalem]

Hi all,

After constructing my model (tables); my main purposes were:

1) Store all tables in QVDs:

FOR i = 0 to NoOfTables()-1 

LET vTabName = TableName($(i)); 

STORE $(vTabName) into [lib://blabla/QVD/$(vTabName)$(vSaveFile).qvd] (qvd); 

NEXT i 

2) drop all the tables (after storing them in qvds) :

//drop tables

FOR j = 1 to NoOfTables()

LET vTabName2 = TableName($(j)); 

Drop table "$(vTabName2)";

NEXT j 

The problem is that the first part (storing the tables works perfectly) while the second one does not.

In fact, from the 15 tables I have, some are deleted and nearly the half ARE NOT.

I have tried :

Drop table "$(vTabName2)";

Drop table '$(vTabName2)';

Drop table $(vTabName2);

Drop table vTabName2;

Nothing works as expected...

When I try the same script with inline tables, all is deleted !

Any idea on what could be the cause of such a behaviour? Thanks

[hariishr]

hi,

i am using QLIK SENSE FEB 2020 and the file extension is QVF, how to use your code. thank you

[Amit]

Awesome script! 🙂