Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Fuzzy Matching One Column of Names

Chris3312
5 - Atom

Hey guys, wondering if you would have any ideas as to a method to turn my data that looks like Table 1 into an end result in Table 2.

I am confused as to what to do once I've outputted my fuzzy match results in regards to putting my data back together again. For example if 'Jimmy Smith' and 'Jimy Smith' gets flagged as a near match and I want them all of these to show up as 'Jimmy Smith' in my data, how do I reflect this update in the second row, making sure any associated values (ID, Value) stay the same?

 

    ID            Name                Value 

    1          Jimmy Smith         120     

    2          Jimy Smith            150     

    3          Charlie Hart            90   

    4          Charlie Hart            75  

    5          Charlie Lart             62  



    ID            Name                Value 

    1          Jimmy Smith         120     

    2          Jimmy Smith         150     

    3          Charlie Hart            90   

    4          Charlie Hart            75  

    5          Charlie Hart            62  

 

Any help would be appreciated.

1 REPLY 1
Thableaus
17 - Castor
17 - Castor

Hi @Chris3312 

 

I did it this way with your dataset and it worked:

F&R.PNG

 

Using Find and Replace Tool, you can take Fuzzy Match Results and change them with the pair values created.

 

Try this with your full dataset and let me know if it works well for you.

 

 

Workflow attached.

Cheers,

Labels