Unique value using RegEx formula not working

Hi,

I am new to Alteryx and trying to find unique values in a particular column separated by comma. While I used available Regex formula for my case, I found two unique values are merged and reporting only one value. Attached example.. Appreciate any help on this.

UniqueValues.yxmd

Common Use Cases

Accepted answers

clmc9601

Hi @TapasDas,

This regex expression (which I adapted from an online forum) worked on the sample data on my end. I hope it helps with your full data!

REGEX_Replace([Mail],"([^,]+)(,[ ]*\1)+",'$1')

All comments

clmc9601

Hi @TapasDas,

Here is a solution that might be easier to understand than regex. If you have to use regex, it might not help. I hope it's helpful though!

Screen Shot 2021-03-06 at 10.31.09 AM.png

UniqueValues.yxmd

TapasDas

Hi ,

Thanks for your suggestion.

As the actual workflow and data files are pretty big with many rows, RegEx formula solution will be more suitable.

Regards,

Tapas

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703