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? 

[Buzz]

HI @DanielKimura ,

I'm not 100% sure if i get what you need.

When you use the join tool, you could look at the left or right output for unmatched entries and the do whatever needs to be done with them. For the others you can select/deselect the fields you want to output at the joing output.

 

[Emil_Kos · Accepted solution]

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/highlig...

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!