Oracle Incremental Load using Qlikview

Wed, 13 May 2015 17:24:44 GMT

Hi,

I modified the attached QlikView document to suit our project. The Incremental qvd file gets generated successfully during the first run but on rerunning to capture the changes, the script fails at the below point -

IF $(QVD_EXISTS) THEN

    // Create the PK for the incremental rows

    RIGHT JOIN ($(datatable)) LOAD DISTINCT

        pyid,

    pxcreatedatetime,

    pxupdatedatetime,

    pystatuswork,

    $(PKexp) as PK

    RESIDENT $(datatable)

    ;

I am not sure why we need a right join here. Please assist.

Thanks,

Sudha.

topic Oracle Incremental Load using Qlikview in QlikView

Oracle Incremental Load using Qlikview