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.
