Fuzzy Name Match

[Hong_Hu]

Hi all,

I'm trying to do some fuzzy match comparisons for names. for example, I have last names like this:

Peeles
Peele
Peeples

They should be similar. However when I use Alteryx Fuzzy Match tool, with match style as "Name", it doesn't return as a match. Any idea how I should do this? Thanks in advance!

[danilang · Accepted solution]

Hi @Hong_Hu 

The Name style in the Fuzzy Match tool is set to work with at least a first and last name.  If you have a first name field, then you should concatenate it with last name with a space in the middle, i.e. "Adam Peele".  If you don't have a first name you can either add the same dummy one to all the records or change the match style to custom and set the Key to Double Metaphone. 

Dan 

[Hong_Hu · Accepted solution]

Got it. This seems to work! Thanks very much!