Let me get straight into it because I'm going crazy over this and it feels that this could be a simple one (which is all the more annoying).
I'm loading a report table1 (csv) then comparing to a master (qvd) and finally saving this into a "new master" (result) table. What I want to achieve is to add any row where a status changes for any given name, maintaining however the "old status" row for historical proposes. I have a feeling that this is a simple join but i just cant make it work for some reason.
Sorry if that's confusing, please have a look on the tables bellow.
Table1: (CSV)
Name
Status
Date
Report Date
Antonio
Poor
10/02/2016
15/01/2017
Andrew
Rich
05/01/2017
15/01/2017
Damien
Rich
12/12/2016
15/01/2017
Master: (QVD)
Name
Status
Date
Antonio
Poor
10/02/2016
Andrew
Poor
20/08/2016
Damien
Rich
12/12/2016
Result: (WILL STORE IT EITHER CSV OR QVD)
Name
Status
Date
Antonio
Poor
10/02/2016
Andrew
Poor
20/08/2016
Damien
Rich
12/12/2016
Andrew
Rich
05/01/2017
I have tried that all day and have bump into all kinds of automatic concatenate /noconcatenate/ outer join/ qvd and csv issues.
Really appreciate if somebody could help me on this.
