Alteryx Designer Desktop Discussions

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

Fuzzy Name Match

Hong_Hu
6 - Meteoroid

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!

 

 

2 REPLIES 2
danilang
19 - Altair
19 - Altair

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
6 - Meteoroid

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

Labels
Top Solution Authors