Streamlining Multiple Concat Values

krishnagandhi

Hi,

I'm having a frustrating time getting rid of repeat values from my concat columns. I have attached the partial data, the issue i am having is in columns 3-9 i have concat'd the data but i have values in each columns which are repeats. I want to only keep the unique values. I started with 966 row and should end with the same. If you look in the workflow i tried a record id and text to rows with a unique tool, but when i do it which all the columns and try to join them it doesn't work.

Any ideas?

Thanks,

Concat Test.yxmd

RobertOdera

Hi, @krishnagandhi 

Try this.

TRIM(REGEX_Replace([Field Name], '\b(.+),(?=.*\b\1,?)', '')) for the fields that you need to process.

If this works for you, please mark as an acceptable solution and like.

Please see the attachment.

Actually, we addressed a similar scenario at the link below (if it had been tagged as a solution, you may have found it easily).

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Remove-Duplicates-from-Comma-Separated-Strings/m-p/573040#M126003

For_krishnagandhi.yxmd