Partial Reload on more than one point

[#1]

Hi Guys,

Is it possible to have more than one partial reload points in a Qlikview file? If so, can you please provide me an example.

Thanks.

Joel

[Gysbert_Wassenaar]

I'm not sure what you mean with the point part in partial reload points. If you want some tables to be partially reloaded during some reloads and other tables during other reloads then you need to construct some way to distinguish one reload from another. You can do this with variables and use if-then blocks to check the variable and either skip or execute the script code inside the if-then block. Does that answer your question?

[SreeniJD]

Hi There,

Please refer this..

Partial Reload Easy and Simple

Sreeni

[#4]

Hi Gysbert,

Yes, that answers my point but can you please edit the example below on where to place the variables so I can understand further.

For example:

Database1:

LOAD  POL_NUM, PLAN_CODE, BIRTH_DT

FROM

Seriatim.xlsx

(ooxml, embedded labels, table is Sheet1);

Mapping1:

REPLACE LOAD Channel, PLAN_CODE

FROM

Mapping1.xlsx

(ooxml, embedded labels, table is Sheet1);

Mapping2:

REPLACE LOAD PLAN_CODE, PAYMENT MAPPING

FROM

Mapping2.xlsx

(ooxml, embedded labels, table is Sheet1);

I want to be able to replace the tables Mapping 1 OR Mapping 2 tables.

Thanks for your time.

Joel