Summarizing Matching Data

[cablejarrett]

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) 

[atcodedog05]

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]

[cablejarrett]

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 · Accepted solution]

Hi @cablejarrett 

Here is how you can do it.

Workflow:

Hope this helps : )

[cablejarrett]

Thank you! this worked. 

[atcodedog05]

Happy to help : ) @cablejarrett 

Cheers and have a nice day!