Fuzzy Matching - Intermediate Users
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
- Mark as New
- Subscribe to RSS Feed
- Permalink
Description:
Names and addresses are a great example of where you may have multiple records for someone due to a slight difference of spelling, abbreviation or punctuation. Fuzzy Matching identifies records which are probably the same person/business which allows you to remove duplicates.
You'll learn how to:
- Use Fuzzy Matching to find which customer records are the same customers but with slight differences in spelling/punctuation/abbreviation
- Navigate the custom settings and better understand the pros and cons of the default matching styles
Tool sets/processes covered:
Presenter: @CailinS
Date: 2016-07-26
Alteryx Designer Version: 10.5
- Labels:
- 10.5
- Data Blending
- Intermediate
- Mark as New
- Subscribe to RSS Feed
- Permalink
Thanks for the excellent training
- Mark as New
- Subscribe to RSS Feed
- Permalink
In both of your Fuzzy Match training videos you show your inverted triangle diagram. The second step down you say "Record pairs found where ALL keys match". Does this mean that the tool looks to see if there are any instances were keys for two records are exact matches?
I am asking this question because I have a case where Fuzzy Match is generating keys but there are some instances where my keys are identical but the tool is not producing a match. I am trying to understand if that is what this portion of your triangle tab is referring to.
- Mark as New
- Subscribe to RSS Feed
- Permalink
Looks like I jumped the gun on this question. More details were provided at 33 mins of this video.