Forum Discussion

AAKASH's avatar
AAKASH
New Contributor
4 years ago

How can we compare two records of same table in SNAPLOGIC without using Diff snap ,I need to use ELT snappacks to implement this

I have old and new data of same table and I need them to compare and find out the inserted and updated records ,how I can use this using ELT snaps I don’t want to use diff snap

1 Reply

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    4 years ago

    What about the Join snap? You can cover quite a few scenarios just by using the Join snap and a Router.
    Example:

    Left Outer Join +
    Router: $.get('id) != null && $.get('input1_id')

    This would be an insertion.

    Left Outer Join +
    Router: $.get(‘updated_date’) != $.get(‘input1_updated_date’)

    And this would be an update.