Comparing from 2 different sources

DanielKimura

I'm trying since yesterday to find difference between one column from two different data sources, one is and excel sheet and another is a flat file(.txt). In those two tables that I have, I did concatenated three columns into a new column (witch is a necessary validation), now I'm trying to find if there is any field that contains in table 1 but not in table two. I already used join but I don't know why the join tool keep adding one to another. Can someone help me? 

Emil_Kos

Hi @DanielKimura,

I don't have access to Alteryx now so I searched for the solutions in the community itself:

This post should explain to you the simplest approach how you can compare the data sets using join tool:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Comparing-data-sets/m-p/359395/highlight/true#M66016

I found also an article about it:

https://community.alteryx.com/t5/Engine-Works/Compare-2-Data-Sets/ba-p/88853

Author of both is Alteryx Aces so I am sure they will give you good guidance!

Please mark my post as a solution if it was helpful and I wish you good luck!