topic Re: Regarding incremental reload in QlikView

Regarding incremental reload

sarfaraz_sheikh — Mon, 24 Nov 2014 13:40:55 GMT

Hi ALL,

If any new field/column is added in Database like oracle,mysql etc....then can we do directly reload or otherwise we will have to do concatenate with existing .....i am confused in that little bit....Please help

Sarfaraz

Re: Regarding incremental reload

sasikanth — Mon, 24 Nov 2014 13:55:42 GMT

HI ,

please go through the Following link

Three Types of Qlikview Incremental Loads | resultdata

Re: Regarding incremental reload

Peter_Cammaert — Mon, 24 Nov 2014 15:27:29 GMT

If your DB table has a primary key, and no records have disappeared from the DB table vs your copy, you can do a JOIN, like:

LEFT JOIN (ResidentTable)

SQL SELECT PK_Field1, PK_Field2, ..., ExtraField1, ExtraField2, ...

FROM SQLTable;

In any other case I would suggest to adjust your script and do a full reload.

Best,

Peter