In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How do I figure out the mismatch of the number in field ?

Kinetic_analytics
11 - Bolide

Hello:

I have two separate report. Where the ID is similar, How do I differentiate match and mismatch of EI Number?

 

ThanksKinetic_analytics_0-1648659331121.png

 

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

Hi @Kinetic_analytics 

 

You would join the two data sets on the ID, then can filter to see if the EINs are the same. in the below, the F anchor shows the 2 instances where they don't match.

 

I suggest checking out the interactive lessons to learn more about the basic functionality of these tools.

 

Luke_C_0-1648660273022.png

 

Kinetic_analytics
11 - Bolide

Thank you for helping me in my learning process.

Labels
Top Solution Authors