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
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.