resident and store into QVD statement

[#1]

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.

[Michiel_QV_Fan]

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]

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]

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]

Hi,

Drop table1 after loading table2