Incremental

[Mahamed_Qlik]

Hello Experts,

Need your help on below case:

I have old QVD and New QVD with following data:

Old.QVD :

Cust ID	Order ID	Confirmation Date	Payment Date
C00001	OD0001	08-Aug	09-Aug
C00002	OD0002	09-Aug	12-Aug
C00003	OD0003	10-Aug	19-Aug
C00004	OD0004	11-Aug	15-Aug
C00005	OD0005	12-Aug	17-Aug

New QVD :

C00001	OD0001	08-Aug	09-Aug
C00002	OD0002	09-Aug	09-Aug
C00003	OD0003	11-Aug	21-Aug
C00004	OD0004	11-Aug	15-Aug
C00005	OD0005	12-Aug	17-Aug

For customer ID - C00003, its confirmation date and payment date has been updated in new QVD.

Now I want to display record from both old as well as new QVD as below:

C00001	OD0001	08-Aug	09-Aug
C00002	OD0002	09-Aug	12-Aug
C00003	OD0003	10-Aug	19-Aug
C00003	OD0003	11-Aug	21-Aug
C00004	OD0004	11-Aug	15-Aug
C00005	OD0005	12-Aug	17-Aug

Kindly help with incremental script.

Regards,

Mahamed