0 Replies Latest reply: Feb 19, 2017 2:12 PM by Antonio Anjos RSS

    Appending / Update QVD

    Antonio Anjos

      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