Fuzzy Matching One Column of Names

[Chris3312]

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.

[Thableaus · Accepted solution]

Hi @Chris3312 

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

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,