Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Row Wise Unique Values

dondapati
7 - Meteor

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

 

4 REPLIES 4
LordNeilLord
15 - Aurora

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
15 - Aurora

Here's an example

Capture.PNG

RishiK
Alteryx
Alteryx

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

LordNeilLord
15 - Aurora

@RishiK 

 

Next quickest answer wins

Labels