05-25-2018 11:36 AM
I’m trying compare different tables in different databases in order to get the no matching datas.
I already tried to use the lookup snap but it doesn’t give an option to get only the no matching records.
Have you guys ever had that same issue? How do I solve this?
Thanks
05-28-2018 01:59 AM
@GABILOBATO Try using Diff Snap
05-28-2018 04:11 AM
I already tried to use it. But somehow it keep sending all the original data to the deleted output even though is not all deleted data.
All the paths has the same data type and are sorted before the diff snap. Don’t know what more I can try
05-28-2018 05:01 AM
Try Reversing Inputs. New to Original and Original to New.
05-28-2018 06:18 AM
Did that too. It inserts the rows at the inserted output