Forum Discussion

rpathak's avatar
rpathak
New Contributor II
4 years ago
Solved

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...
  • del's avatar
    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