about partial reload, urgent!

[#1]

i have script like below:

LOAD cloum_1 RESIDENT talbe_A;
LOAD cloum_1 RESIDENT talbe_A;
LOAD cloum_1 RESIDENT talbe_A;
LOAD cloum_1 RESIDENT talbe_A;

as we know, qlikview will treat this group as one table.

Now, if i want to do

LOAD cloum_1 RESIDENT talbe_A;
replace LOAD cloum_1 RESIDENT talbe_A;
LOAD cloum_1 RESIDENT talbe_A;
LOAD cloum_1 RESIDENT talbe_A;

it's failed, what should i do to add the new data in, and still keep orthers?

Thanks a lot

[#2]

sorry it should be:

LOAD cloum_1 RESIDENT talbe_A;
LOAD cloum_1 RESIDENT talbe_B;
LOAD cloum_1 RESIDENT talbe_C;
LOAD cloum_1 RESIDENT talbe_D;

[prieper]

There is no identifyer to refer to the source-table. Do you think that you may add the table, like

LOAD cloum_1, 'A' AS source RESIDENT talbe_A;
LOAD cloum_1, 'B' AS source RESIDENT talbe_B;
LOAD cloum_1, 'C' AS source RESIDENT talbe_C;
LOAD cloum_1, 'D' AS source RESIDENT talbe_D;

This way you may continue:

xTable: LOAD * RESIDENT Table WHERE source <> 'B';
LOAD cloum_1, 'B' AS source RESIDENT talbe_B;
DROP TABLE Table;
RENAME TABLE xTable TO Table;

edit: you need to use the ADD-phrase in order to have it working as partial reload

HTH
Peter

[msteedle]

Agree. If you want to keep the existing data, you should be using an ADD rather than REPLACE LOAD. In a partial reload, the way it is written, the existing table would be dropped, and only the data from table B would be added back to it. Even in a normal reload, the data from table A would never make it into the final application.

[#5]

Thanks a lot. It works....