Forum Discussion

rpathak's avatar
rpathak
New Contributor II
5 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 checking.

please help me to find the exact error. Mentioned below is the pipeline for your reference.

first time result only for insert is correct:-

for Update wrong:-

diff and Update snap details:-

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

2 Replies

  • del's avatar
    del
    Contributor III
    5 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

  • rpathak's avatar
    rpathak
    New Contributor II
    5 years ago

    Hi @del,

    Thank you for the reply. The issue has been resolved using your given suggestion.

    Regards
    Ratnakar