community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Join us for a weekly live session on a variety of topics that range from beginner to advanced. You can also playback previously recorded live trainings.
Live Training
Join us for a weekly live session on a variety of topics that range from beginner to advanced. You can also playback previously recorded live trainings.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Live Training: Fuzzy Matching - Intermediate Users

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

 

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

Highlighted
Meteor

This training was excellent.  One thing I was struggling with was the duplicate records that came out of the fuzzy match tool.  Cailin explains why this happens and what to do.  Thank you Cailin.

Atom

Thanks for the excellent training

Meteoroid

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.

Meteoroid

Looks like I jumped the gun on this question. More details were provided at 33 mins of this video.