Skip to main content

Purple box with two similar shapes and equals signs between. Fuzzy Match Tool

One Tool Example

Fuzzy Match has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.

Use Fuzzy Match to identify non-identical duplicates of a dataset by specifying match fields and similarity thresholds. Match Scores only need to fall within the user-specified or default thresholds established in the configuration properties.

The most effective way to build a fuzzy match is to perform the match process on multiple fields within the input file. Each field should be individually configured using either a predefined or custom Match Style, configured through the Fuzzy Match Edit Match Options.

Fuzzy matching only works with Latin and Japanese character sets, and some of the match capabilities are only compatible with English or Japanese. Fuzzy matching accounts for various differences in Japanese orthography, such as half-width and full-width characters, hiragana and katakana, kana modifiers, and old kanji forms.

Configure the Tool

A unique identifier for each data record is necessary for the Fuzzy Match tool to work. Inspect your data—if there is no such key field, add a Record ID tool one step upstream.

  1. Choose the preferred match mode:

    • Purge Mode (All Records Compared): All records from a single source are compared to identify duplicates.

    • Merge Mode (Only Records from a Different Source are Compared): Records from different sources are compared, with the intent to identify duplicates across different input files. When you use Merge mode, each source must contain a Source ID Field. A source ID field can is easily appended by choosing the Output File Name as Field option within each Input Data tool. This setting will append to each record a field with either the File Name or the entire File Path.

  2. Specify the unique Record ID Field.

  3. Specify the Match Threshold as a percentage. The default value is 80%. If the Match score generated from the Fuzzy Match tool is less than the specified threshold, the record will not qualify as a match. The Match score takes into consideration each specification within the configuration properties of the Fuzzy Match tool: Each field, the match style, the match weight, and the resulting field match score is considered in calculating the score, which is then against the specified Match Threshold.

  4. Set up your Match Fields. Use Up and Down to arrange them in order of matching. Use Delete to remove unneeded matches.

    1. Select the Field Name to match on. Any field already in the input connection will be available from this dropdown list.

    2. Select the Match Style from the dropdown list. Choices include:

      • Address: A predefined match style configured to find address matches. This style incorporates Double Metaphone algorithms combined with a digit match to identify matching addresses. Apply this style to Commercial Addresses.

      • Address No Suite: A predefined match style configured to find address matches where the input data has no suite information in the Address field. This style incorporates Double Metaphone algorithms combined with a digit match to identify matching addresses. Apply this style to Residential Addresses.

      • AddressPart: A predefined match style configured to find address matches. This style incorporates Double Metaphone algorithms combined with a digit match to identify matching addresses. AddressPart differs from a traditional address match style in that it does not use word frequency analysis and the match threshold is 5% lower.

      • Company Name: A predefined match style configured to find company name matches. This style identifies matches based on Double Metaphone algorithms.

      • Phone: A predefined match style configured to find phone matches. This style looks at the digits only in a phone field and matches on the reverse 10 digits, ignoring dashes, parentheses, and leading 1s that might be part of the field. This style also supports the Japanese phone number format.

      • ZIP Code: A predefined match style configured to find ZIP code matches. This style looks at the 5 digits of a ZIP field and assigns a match accordingly.

      • Exact: This field must match exactly to be considered a match. This logic is not fuzzy at all.

      • Japanese Address: A predefined match style configured to find Japanese address matches, including varying street number formats. Match example: 今津3-14-19 and 今津3丁目14番地19.

      • Japanese Company Name: A predefined match style configured to find Japanese company name matches. Match example: 株式会社伊藤工務店, (株)伊東工務店 and ㈱伊藤工務店.

      • Japanese Name: A predefined match style configured to find Japanese name matches. Match example: 高橋 啓介 and 髙橋啓介.

      • Japanese Text: A predefined match style for Japanese text other than the Address, Company name, and Name options. Match example: 6ヵ月 and 6ヶ月.

      • Name: A predefined match style configured to find name matches. This style incorporates Double Metaphone algorithms.

      • Name with Nicknames: A predefined match style configured to find name matches. This style incorporates Double Metaphone algorithms. Additionally, this style utilizes a Nicknames table to check against to further identify duplicates. For example, the name Andrew may match Andy and/or Drew.

      • Custom: Allows the user to define their own match parameters, so that the match can be run repeatedly without having to reconfigure the match properties. Of course, these custom match styles can also be reconfigured and overwritten or new custom styles can be created.

    3. Use the Edit... button to edit the Match Style as necessary. The Fuzzy Match Edit Match Options dialog displays.

  5. Specify Advanced Options:

    • Output Match Score: The match score will be present in an additional output field.

    • Output Generated Keys: Outputs the key from the resulting match styles as an additional field.

    • Output Unmatched Records: Records that do not match any other records will output as additional records. Occasionally, output unmatched records will report a match score, which should be ignored. This may be addressed in a future release. The Ignore if empty option from the Edit Match Option is prioritized over this option.

    • Don't Compare Records already in a Group: Records that have been matched will not both be compared to other records, reducing processing effort and time. For example, If record 1 matches to record 2 and record 3, then record 2 is not matched against record 3. Use a Make Group tool downstream to link these groups together.

    • Generate Keys Only: All records are returned with the generated keys as an additional field. No matching takes place.

For additional information regarding Fuzzy Match use, go to Fuzzy Match FAQ.