This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 02-02-201705:43 PM - edited on 07-07-202002:07 PM by kcsrestapiuser
This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Fuzzy Match Tool on our way to mastering the Alteryx Designer:
In life, there are few things black and white. There are gray areas everywhere and the lines that separate can be a little fuzzy. The same holds true for data – especially when it’s human entered. That’s why we have the Fuzzy Match Tool – if your data isn’t clear as day, you can still get value out of your records by matching them to something a little more standardized. This can be useful when:
Purging (deduping) a singular dataset of duplicate records (attached in Fuzzy Match.yxmd):
Merging two datasets and identifying redundant records (attached in Fuzzy Match.yxmd):
Note: It is highly recommended to first purge (dedupe) each of your merging datasets before using them in merge mode so as to eliminate any redundant matches - this will speed up the matching process considerably.
These techniques will help you identify similar names, addresses, phone numbers, and even misspelled words in your data that will help make inexact strings into exact analyses!
If you’re working specifically with names, be sure to check out our guide to nickname fuzzy matching. If you find yourself having to loosen the Match Threshold to the point where some strings are incorrectly matching, but you still aren’t getting others, try “waterfalling” the matching process with another Fuzzy Match Tool just for the lower threshold strings you’re looking to add and union them back to the matched set.
By now, you should have expert-level proficiency with the Fuzzy Match Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know firstname.lastname@example.org if you’d like your creative tool uses to be featured in the Tool Mastery Series.
Stay tuned with our latest posts everyTool Tuesdayby followingAlteryxon Twitter! If you want to master all the Designer tools, considersubscribingfor email notifications.