Regarding incremental reload

[sarfaraz_sheikh]

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

[sasikanth]

HI ,

please go through the Following link

Three Types of Qlikview Incremental Loads | resultdata

[Peter_Cammaert]

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