rpathak
4 years agoNew Contributor II
How to Implement Update in Diff Snap
Hi,
Using diff I am able to insert new records in the table, but for an update, it is not working either it will update all the records with the latest record or insert the new record without check...
- 4 years ago
Hi @rpathak,
For your update snap, you will need to include a record identifier condition in the Update Condition field. Otherwise, for every input record, it updates all the records in the table matching the
UPDTD_TS>=getdate()-2
condition.So you might change your current Update Condition to something like:
COUPON_ID = $COUPON_ID and UPDTD_TS>=getdate()-2