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
