Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

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;

Highlighted
michielvandegoo
Not applicable

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;

ashfaq_haseeb
Not applicable

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

its_anandrjs
Not applicable

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
Not applicable

Re: resident and store into QVD statement

Hi,

Drop table1 after loading table2