topic about partial reload, urgent! in QlikView

about partial reload, urgent!

Tue, 02 Feb 2010 22:37:53 GMT

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

about partial reload, urgent!

Tue, 02 Feb 2010 22:40:23 GMT

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;

about partial reload, urgent!

prieper — Tue, 02 Feb 2010 22:56:29 GMT

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

about partial reload, urgent!

msteedle — Wed, 03 Feb 2010 05:58:31 GMT

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.

about partial reload, urgent!

Thu, 04 Feb 2010 13:10:28 GMT

Thanks a lot. It works....