cancel
Showing results for 
Search instead for 
Did you mean: 

Writing no matching data

GABILOBATO
New Contributor II

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

6 REPLIES 6

SandeepVemula
Contributor

@GABILOBATO Try using Diff Snap

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

Try Reversing Inputs. New to Original and Original to New.

Did that too. It inserts the rows at the inserted output