Hi all,
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.
Apologies in advance if that's too easy.
Best Regards
Antonio