ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Fuzzy Match: Words Levenshtein Distance Approach

mshinn9999
7 - Meteor

Hello all. I have a conceptual question on the Fuzzy Match tool (PURGE).  I am trying to de-dupe/consolidate University names.  After cleansing the data (de-duping, getting rid of spaces, etc.), I ran the Funny match logic and leveraged the "Generate Keys for Each Word" approach, along with the Words - Levenshtein Distance Match function method. 

 

Assuming that this is not too generic of a question, how do I get below sample data set as ONE single record vs 3?  Below represents the types of data patterns that I see.  Is there another setting that I should consider? (data is dummied up).

 

Mike

 

Texas A M Univ

Texas A M University

Texas A M University College Station

 

1 REPLY 1
alexnajm
19 - Altair
19 - Altair

This is normal behavior because of the key generation - use a Unique tool afterwards to get a unique list of the fuzzy matches!

Labels
Top Solution Authors