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

[AAKASH]

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]

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.