Removing duplicate values in each cell

Hi @wonka1234 : here is a great resource outlining different approaches to removing duplicates within a cell: Remove-Duplicates-within-a-cell

Let me know if this helps!

Dana

*updated link* apologies!

ShankerV

Hi @dana_mcdonough

The Link shared is not working, can you please update the new link. Will help me too.

wonka1234

@Felipe_Ribeir0

Thank you , this works. But how to apply this across multiple columns without having to repeat this all the time?

Felipe_Ribeir0

Hi @wonka1234

You can transpose the dataset before removing the duplicates:

Removing duplicate values in each cell.yxmd

EN6924

Text to columns : Delimiter ";" and split to rows

Summarize: Concatenate and Separator ";"

htalteryx

I have multiple fields (10+ fields) with duplicate values in the cell. How would you solve? Is there a better way than copying/pasting ShankerV's solution multiple times on the canvas? Thanks in advance!

Felipe_Ribeir0

Hi @htalteryx

I suggest you to create a new topic showing a dummy sample of how your input/expected output looks like.

htalteryx

Already did. I was able to solve on my own. Thanks!

Solved: Re: Multiple fields with duplicates in each field - Alteryx Community

muhammadimranhakimi

Thanks for the discussion!

Adamyde

👍

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167