< Previous | Next >

Lesson 3.2: Importing and adding lookup table definitions

In this lesson, you will import and add lookup table definitions to the Street_Name lookup table.

About this task

Overview

The fictional Sample Outdoor Company created a CSV file that contains lookup table definitions for the Street_Name lookup table. You can import these definitions into the lookup table that you added in the Standardization Rules Designer.

Recently, the company discovered a new abbreviation in the address data and identified a typographical error in a lookup table definition. You can update the lookup table by adding lookup table definitions in the Standardization Rules Designer.

Learn more about lookup table definitions:

Lookup table definitions include the following elements:

Value
The input value that is defined.
Returned Value
A value that an action or condition in a rule can use instead of the input value.
Similarity Threshold
The degree of variation that is allowed in the spelling or representation of the value. The similarity threshold must be in the range 700 - 900. A similarity threshold of 900 indicates that only the exact value in the definition is affected by the definition.

If the similarity threshold is lower than 900, the definition might affect values that are similar to the value in the definition. For example, if you create a lookup table definition for the value GRAMS and set the similarity threshold to 800, the lookup table definition also affects the value GRAM.

Procedure

Procedure

  1. Importing lookup table definitions
  2. Adding lookup table definitions

Importing lookup table definitions

You can import lookup table definitions from one or more files into a lookup table in the Standardization Rules Designer. You can also add lookup table definitions manually in the Standardization Rules Designer.

About this task

Procedure

Procedure

  1. In the Standardization Rules Designer, click the Lookup Tables tab.
  2. From the list of lookup tables, select the Street_Name table. A list of values in the lookup table is shown in the right pane. Because no values are defined for this lookup table, the list is empty.
    The pane for the Street_Name lookup table does not contain any values. In the Values column, a message indicates that no values have been added to the lookup table.
  3. From the Define Values list, select Import.
  4. Import the street_abbreviation_lookup.csv file:
    1. Browse to the directory that contains the file. By default, the file is in the Standardization_Rules_Designer_address_tutorial directory where you copied the tutorial files.
    2. Select the file, and then click Open.
    3. In the Import Definitions window, click OK.

Results

The lookup table definitions are imported and the right pane shows the values in the lookup table that are defined.
The pane for the Street_Name lookup table contains information about the definitions that were imported. The abbreviated street name is shown in the Value column, and the name that is spelled out is shown in the Returned Value column.

Adding lookup table definitions

You can add lookup table definitions manually in the Standardization Rules Designer.

About this task

Procedure

Procedure

  1. For the Street_Name table, select Define Values from the Import list.
  2. Add a lookup table definition for the new value by completing the fields:
    1. In the Value field, enter the abbreviation IB.
    2. In the Returned Value field, enter the street name IRLO BRONSON.
    3. Expand Define Value As and ensure that Active definition is selected. An inactive definition does not affect the value.
    4. Click OK.
    The right pane shows the value that you added a definition for.
    The pane shows the value that was added in the list of values for the lookup table.
  3. Create a new lookup table definition for a value by repeating step 2, but entering SP for the value and SARA PELLETIER for the returned value.
  4. Verify that the new lookup table definition is the active definition:
    1. From the list of lookup tables, select the Street_Name table. A list of values in the lookup table is shown in the right pane.
    2. From the list of values, select SP. A list of definitions for the value is shown on the Define Value page. The definition that you added is selected, and is therefore the active definition.
      Two definitions for the value SP are shown. The definition that was added is selected, which indicates that this definition is active.

What’s next

In this module, you completed the following tasks:
  • Added a lookup table
  • Imported lookup table definitions
  • Added lookup table definitions

In the next module, you will create and modify rules that handle the addresses in customer records for the fictional Sample Outdoor Company.

< Previous | Next >