Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Comparing from 2 different sources

DanielKimura
6 - Meteoroid

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? 

2 REPLIES 2
Buzz
8 - Asteroid

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.

 

Buzz_0-1606423792925.png Buzz_1-1606423824169.png

 

 

 

Emil_Kos
17 - Castor
17 - Castor

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!

Labels