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 |
Solved! Go to 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
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: