Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Appending / Update QVD

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