In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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