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

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