Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

resident and store into QVD statement

Hi, I have 2 tables and the script is as such:

table1:

load *

from [filepath]

((txt, codepage is 1252, embedded labels, delimiter is '|', msq);

store table1 into table1.QVD;

drop table table1;

table2:

load*

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;'

Thanks.

5 Replies
michielvandegoo
Valued Contributor

Re: resident and store into QVD statement

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.

table2:

load*

FROM table1.qvd

order by variablename desc;

store table2 into table2.QVD;

michielvandegoo
Valued Contributor

Re: resident and store into QVD statement

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.

table2:

load*

FROM table1.qvd

order by variablename desc;

store table2 into table2.QVD;

Re: resident and store into QVD statement

Hi Try below

table1:

load *

from [filepath]

((txt, codepage is 1252, embedded labels, delimiter is '|', msq);

store table1 into table1.QVD;

drop table table1;

noconcatenate

table2:

load*

resident table1 order by variablename desc;

store table2 into table2.QVD;

drop table table2;

Regards

ASHFAQ

Re: resident and store into QVD statement

Try with

table1:

load *

from [filepath]

((txt, codepage is 1252, embedded labels, delimiter is '|', msq);

Noconcatenate

table2:

load *

resident table1 order by variablename desc;

store table2 into table2.QVD;

drop table table1;

drop table table2;

meet_purushu
New Contributor III

Re: resident and store into QVD statement

Hi,

Drop table1 after loading table2