topic resident and store into QVD statement in QlikView

resident and store into QVD statement

Thu, 07 Aug 2014 06:08:13 GMT

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.

Re: resident and store into QVD statement

Michiel_QV_Fan — Thu, 07 Aug 2014 06:12:48 GMT

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

Michiel_QV_Fan — Thu, 07 Aug 2014 06:13:20 GMT

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

ashfaq_haseeb — Thu, 07 Aug 2014 06:15:24 GMT

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

its_anandrjs — Thu, 07 Aug 2014 06:38:17 GMT

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;

Re: resident and store into QVD statement

Anonymous — Fri, 01 Apr 2016 09:37:28 GMT

Hi,

Drop table1 after loading table2