Resident load table not loading

[Anonymous]

Hello, I'm having trouble with Resident load

Syntax

SQL_table:

SQL

select distint *

from table;

Store SQL_Table into xxxxx;

Final:

LOAD *

Resident SQL_table;

drop table SQL_table;

Table Final does not exitst, why?

[swuehl · Accepted solution]

the table gets auto-concatenated, try

Final:

NOCONCATENATE

LOAD *

Resident SQL_table;

[#3]

you hav 2 tables that are exactly the same so QlikView will automatically concetnate them together - when you look at the table you ahve, it will ahve twice the amount of entries it should have

what is the purpsoe of doing the resident load after the intial load?