Fuzzy Name Match
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Fuzzy Match
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Got it. This seems to work! Thanks very much!
