Need help with deleting records

qlikuser222 — Fri, 09 Dec 2016 17:49:09 GMT

Hi,

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

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

Re: Need help with deleting records

maxgro — Fri, 09 Dec 2016 20:23:02 GMT

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)

;

topic Re: Need help with deleting records in QlikView

Need help with deleting records

Re: Need help with deleting records