Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Michiel_QV_Fan
Specialist
Specialist

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;

Michiel_QV_Fan
Specialist
Specialist

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
Champion III
Champion III

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

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;

Anonymous
Not applicable
Author

Hi,

Drop table1 after loading table2