identifying unique and different values across multiple columns

[Pran19G]

Hey,

New to the alteryx community!

I'm trying to identify how many times a value occurs across multiple columns, to find the columns with the same value and those with different ones - whilst ignoring the null values.

E.g. Input

RecordID	Column A	Column B	Column C	Column D
1	10	10	null	null
2	5	null	null	5
3	10	10	10	10
4	10	10	5	5

Desired Output:

RecordID	Unique/repeated values only	Multiple values
1	YES	NO
2	YES	NO
3	YES	NO
4	NO	YES

The outputs don't have to say yes or no, can be binary 1,0 - I just need help identifying which ones have the same value and which don't.

Appreciate any assistance!

Thanks

[jdunkerley79 · Accepted solution]

I would suggest:

First transpose the data to be row based and filter the Nulls

Use a summarise tool to compute distinct value counts by record ID

You can then use a formula tool to make the 2 columns

Have attached a sample

[Emil_Kos]

Hi @Pran19G,

I believe this is the same aproach as @jdunkerley79 

[Pran19G]

Thank you, worked perfectly!!

[Pran19G]

Thank you Emil - this worked perfectly too!