Discussion Board for collaboration on QlikView Scripting.
Hi, I have 2 tables and the script is as such:
((txt, codepage is 1252, embedded labels, delimiter is '|', msq);
store table1 into table1.QVD;
drop table table1;
resident table1 order by variablename desc;
store table2 into table2.QVD;
drop table table2;
How can I store table2 as QVD also? I have error stating table1 not found when the program runs 'resident table1 order by variablename desc;'
This is because you drop table1. Resident loads a previously loaded table which is in memory. A dropped table is gone from memory.
You need to load the QVD instead.
order by variablename desc;
Hi Try below
Drop table1 after loading table2