Discussion Board for collaboration on QlikView Scripting.
To find out how incremental reload and storing into a QVD file works from the result of sql include multiple tables ( 3 tables)..
Here is the data sql what i want to do incremental reload and store;
TRUNC(P2.UPDATE_DATETIME) as PD_UPDATE_DATETIME,
TRUNC(P1.UPDATE_DATETIME) as PT_UPDATE_DATETIME,
TRUNC(P3.UPDATE_DATETIME) as PB_UPDATE_DATETIME
FROM PROMOTION_DEFINITION P1,
WHERE P1.PROMOTION_NO = P2.PROMOTION_NO
AND P1.PROMOTION_NO = P3.PROMOTION_NO
AND WT.DATE BETWEEN P1.SALE_START_DATE AND P1.SALE_END_DATE
Note: all table have an update_datetime column.
According to informations above.. how can i get only new and updated rows from datasource ( database).
I hope someone can explain the me.
Hi , you can apply the incremental load on the raw table extract into qvd. After that apply the transforms on the qvd what you are applying in sql query.