dropping all the tables that fulfill a condition

[yacine]

i want to drop multiples tables after exxtracting the necessary data from them. I used the solution (from https://community.qlik.com/t5/QlikView-App-Dev/Delete-all-resident-tables/td-p/221483) : 

let numTables = NoOfTables();
for i=1 to $(numTables)
 let tt = TableName(0);
if  ('$(tt)' <> 'Data_22')
 drop table [$(tt)];
endif
next i;

This  seem to be working only the first time i used it to drop tables. I used it multiples times within the script editor and only the first time was succesfull. Can someone pls help me out with this. Thank you in advance.

[rwunderlich · Accepted solution]

I find it easier and more reliable to loop from last table number to first. 

FOR i = NoOfTables()-1 to 0 STEP -1
let tt = TableName($(i));
if  ('$(tt)' <> 'Data_22')
 drop table [$(tt)];
endif
next i;

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com 

[yacine]

thank you mister.