Row Wise Unique Values

dondapati

Hi Experts,

Problem:- Find the Unique Values in Each Row.

Input:-
Col1

a,b,a

b,b,c,c,a,s

c,a/c,c,a/c,e

Output:

a, b

a, b, c, s

c, e, a/c

Here operation happens only on single column and find the unique values in a each row.

I am not sure how to perform this operation.

Any help appreciate .

Thank you

Workflow

Accepted answers

LordNeilLord

Here's an example

unique.yxmd

All comments

LordNeilLord

Hey @dondapati

If you add a recordid and split your column to rows (Text to Columns) then you can you use unique to remove the duplicates. Lastly summarize tool to concat the column back together again

LordNeilLord

Here's an example

unique.yxmd

rkapoor

@LordNeilLord we following each other round today? You beat me to it on this one.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703