Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!

Alteryx Designer Desktop Discussions

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

RECORD CHECKING IN TWO TABLE

kathbanc
8 - Asteroid

HI! 

 

I have two tables with the same column. 

My output should be , to display record that are not exist in TABLE A ( Reference Table). thank you in advance

kathbanc_0-1686923739804.png

 

2 REPLIES 2
ScottLewis
11 - Bolide

Join the two tables on NAME with table A as the left input and table B as the right input. The Right Output Anchor of the Join will contain the records in B that were not also in A. 

 

ScottLewis_0-1686924085279.png

 

kathbanc
8 - Asteroid

thank @ScottLewis! It works. 

Labels
Top Solution Authors