Fuzzy Match: Words Levenshtein Distance Approach

mshin — Tue, 04 Jun 2024 20:06:12 GMT

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

Re: Fuzzy Match: Words Levenshtein Distance Approach

alexnajm — Tue, 04 Jun 2024 22:24:08 GMT

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

topic Re: Fuzzy Match: Words Levenshtein Distance Approach in Alteryx Designer Desktop Discussions

Fuzzy Match: Words Levenshtein Distance Approach

Re: Fuzzy Match: Words Levenshtein Distance Approach