Need help with deleting records

[qlikuser222]

Hi,

I have a requirement where i need to delete changed records and update them with new records.

Previous:

load * inline [

ID, Date, Status

1, 1, Open

2, 1, Open

3, 1, Open

4, 1, Open

5, 2, Open];

Current:

load * inline [

ID, Date, Status

1, 2, Open

2, 3, Open

3, 3, Close

4, 3, Close

6,3,Close];

My outcome should be like below, I want all changed records (example ID 1,2,3,4) , newly added records (example ID 6) from Current table along with the unchanged records in Previous table (example ID 5). Please help

ID, Date, Status

1, 2, Open

2, 3, Open

3, 3, Close

4, 3, Close

6,3,Close

5, 2, Open];

Thanks

[maxgro · Accepted solution]

Current:

load * inline [

ID, Date, Status

1, 2, Open

2, 3, Open

3, 3, Close

4, 3, Close

6,3,Close

];

Concatenate (Current)

//Previous:

load * inline [

ID, Date, Status

1, 1, Open

2, 1, Open

3, 1, Open

4, 1, Open

5, 2, Open

]

Where not Exists (ID)

;