โ01-03-2022 03:41 AM
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
โ01-03-2022 07:54 AM
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.