Data Cleansing Query

Question

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/PO/PA,AAA,B,B,CA,B,CA,B,C,CA,B,CA,B,C,D,DA,B,C,DA,B,C,D,E,EA,B,C,D,EA,B,C,D,E,F,GA,B,C,D,E,F,GA,B,C,DA,B,C,DA,B,C,D,EA,B,C,D,EA,A,B,B,C,C,DA,B,C,D

AngelosPachis · Accepted Answer

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 Answer

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: