topic Re: Partial Reload on more than one point in QlikView

Partial Reload on more than one point

Wed, 07 Oct 2015 02:30:45 GMT

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

Re: Partial Reload on more than one point

Gysbert_Wassenaar — Wed, 07 Oct 2015 05:23:27 GMT

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?

Re: Partial Reload on more than one point

SreeniJD — Wed, 07 Oct 2015 05:27:15 GMT

Hi There,

Please refer this..

Partial Reload Easy and Simple

Sreeni

Re: Partial Reload on more than one point

Wed, 07 Oct 2015 05:44:29 GMT

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