We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

To find duplicate names and changes to one

mmustkee
10 - Fireball

Hi Team,

 

I have a column in which we have specific names and their duplicate one also. For example we have  'Sam/ Mohd and Sam/M' i should be changed to one name either of name 'Sam/Mohd or Sam/M.

Another example 'Main James/ Huss and Main J/ Huss'

Do we have anything to find and sort this out? Please find attached.

Thanks in advance.

 

 

Name
Sam/ Mohd
Main J/ Huss
Sam/M
Huss Fuss/ Corola
Sameer Sa/ Gail
Huss Fuss/ C
Sam/Mohammad
Main James/ Huss
Asad Moa/ Main
Tres Sagar/ Ani
Agr/Nav M
Agr/Nav
Ash/ Tam
Tam/Ash
Kar Anr/ Say
Kar Anr/ S
Agr/Nav Mr

 

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@mmustkee 
I am not an expert but this Fuzzy match is always tricky and can not get what we really need.😂

Labels
Top Solution Authors