- 2415 Views
- 2 replies
- 0 kudos
Resolved! How do I merge two tables and track changes to missing rows as well as new rows
In my scenario, the new data coming in are the current, valid records. Any records that are not in the new data should be labeled as 'Gone", any matching records should be labeled with "Updated". And finally, any new records should be added.So in sum...
- 2415 Views
- 2 replies
- 0 kudos
Latest Reply
- 0 kudos
Detection deletions does not work out of the box.The merge statement will evaluate the incoming data against the existing data. It will not check the existing data against the incoming data.To mark deletions, you will have to specifically update tho...
- 0 kudos