Fuzzy Lookup

Contents[Hide]

The Fuzzy Lookup transform allows searching for a matching recording from a secondary table when no relationship key fields are defined between two tables.

Transform - Fuzzy Lookup
Transform - Fuzzy Lookup

1. Input

The Fuzzy Lookup transform requires requires 2 input transforms.

The input could be a SQL Select transform, or the result of another transform. For example, the input data is:

Input Data
Input Data

2. Add the Transform

Steps to add the transform:

  1. Select the connector link.

    Adding the Fuzzy Lookup transform - Step 1
    Adding the Fuzzy Lookup transform - Step 1

  2. Select the transform from the menu.

    Adding the Fuzzy Lookup transform - Step 2
    Adding the Fuzzy Lookup transform - Step 2

  3. Connect the SQL Select transform (SalesAgent) and the Fuzzy Lookup transform.

    Adding the Fuzzy Lookup transform - Step 3
    Adding the Fuzzy Lookup transform - Step 3

  4. To Edit/Configue the transform, select the newly added transform, and click the Configure menu.

    Adding the Fuzzy Lookup transform - Step 4
    Adding the Fuzzy Lookup transform - Step 4

3. Configure

Steps to configure the Fuzzy Lookup transform:

Fuzzy Lookup transform configuration
Fuzzy Lookup transform configuration

  1. Select the columns to be included in the output.
  2. Drag element(s) from the Input table to the Lookup Table (or vice-versa) to create a unique key binding.
  3. Enter the Probability Threshold. Valid values are from .0001 to 1.0. Value of 1.0 will require input data to be an "exact match" for them to be looked up successfully.
  4. Enter Maximum matches value to return the maximum number of output records that can be returned from each input, when multiple matches are found.
  5. Select Ignore String Case if you want a non-case sensitive match.

4. Output

The figure below illustrates the output from the Fuzzy Lookup transform.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri