Data Cleansing Query

[gankita181]

Hi Team,

For below data  where I need unique values in output . 

I have used logic is input data -> Text to Column -> Transpose ->Unique -> Concatenate -> Transpose this works in excel but not in Alteryx please suggest 

I/P	O/P
A,A	A
A,B,B,C	A,B,C
A,B,C,C	A,B,C
A,B,C,D,D	A,B,C,D
A,B,C,D,E,E	A,B,C,D,E
A,B,C,D,E,F,G	A,B,C,D,E,F,G
A,B,C,D	A,B,C,D
A,B,C,D,E	A,B,C,D,E
A,A,B,B,C,C,D	A,B,C,D

[AngelosPachis · Accepted solution]

Hi @gankita181 ,

What you can do in this instance is use a text to columns tool to split all your characters to rows based on "," as a delimiter. Then for each string group, you can remove the duplicate occurrences of a character and then concatenate them back together

Hope that helps,

Cheers,

Angelos

[Emil_Kos · Accepted solution]

Hi @gankita181,

I have preared a workflow for you.

The last join might not be required it depends if you want to keep the data in the original order:

Output: