Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
thank you mister.