To get the unique values from Column.

[sri1227]

Hi Guys,

I need a help to the unique values from the column 

Ex :

Column A    Column B

1000             AA

1000             BB,AA

1000             CC,BB

2000             EE,GG,FF

2000             EE,SS,HH

2000             HH

Expected 

1000            AA,BB,CC

2000            EE,FF,GG,HH,SS

Is there way to get the output like this. Am new to Alteryx if anyone help me its really useful.

[Felipe_Ribeir0]

Hi @sri1227 

One way of doing this

[MarqueeCrew]

@sri1227 ,

 If you first use a text to columns you can parse on comma for field two and choose to split to rows.  You will get column 1 plus the value of column two. 

now you can unique on column one and two

 now summarize with a group on column one.  The second thing to do in the summarize is to select the column two and under the string functions you will see concentrate.  Concentrate in column two. 

presto!  You're done. 

cheers,

 mark

[ShankerV]

Hi @sri1227 

Here is your expected output.

Many thanks

Shanker V

[binuacs]

@sri1227 One way of doing this