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!
Solved! Go to 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
Got it. This seems to work! Thanks very much!