Summarizing Matching Data

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)

Workflow

Accepted answers

Hi @cablejarrett

Here is how you can do it.

Workflow:

Hope this helps : )

duplicates.yxmd

All comments

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 : )

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.

Hi @cablejarrett

Here is how you can do it.

Workflow:

Hope this helps : )

duplicates.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

Hollingsworth 335