Alteryx Designer Desktop Discussions

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

Summarizing Matching Data

cablejarrett
6 - Meteoroid

Good morning! I am new to Alteryx and have a pretty simple task I need help with. 

 

currently trying to find out which one of our customers has different data in a specific field. 

 

in the example below the first column is the same customer but different order Type.( I want to identify those) 

 

 

cablejarrett_0-1645557369193.png

 

6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

Hi @cablejarrett 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

cablejarrett
6 - Meteoroid

cablejarrett_0-1645557792196.png

 

cablejarrett
6 - Meteoroid

I have a data set 60k lines I need to determine in this data set where the same value in the first column has different values in the 2nd.  the yellow example is where I want to identify. Orange is fine and I don't

need to pull those out.

atcodedog05
22 - Nova
22 - Nova

Hi @cablejarrett 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645558144843.png

 

Hope this helps : )

 

cablejarrett
6 - Meteoroid

Thank you! this worked. 

 

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @cablejarrett 

Cheers and have a nice day!

Labels
Top Solution Authors