Appending / Update QVD

Sun, 19 Feb 2017 19:12:08 GMT

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

topic Appending / Update QVD in App Development

Appending / Update QVD