Recoding Data Values - trillium_discovery - trillium_quality - 17.2

Trillium Control Center
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:56:48.630530

Each attribute contains a certain number of distinct data values. A value recode is a user-defined revision or recoding of a distinct data value which modifies or replaces the original value.

Recoded values are useful, for example, if you are standardizing the way your company enters phone numbers into a database or the way you enter data for customer addresses and postal codes. With value recoding you can apply global changes to data formats and structures, and be assured that the resulting data values are consistent in their format and presentation. The Quality Transformer process can use tables of recoded values to standardize and clean data.

Example

An address value can be recoded, such as ROAD to RD or STREET to ST. For an attribute that contains name values, DR. can be recoded as Dr and MR. as Mr.

Each record in a recode table contains two columns:

  • original value
  • new value
Example

In this scenario, state names in your State attribute have been entered inconsistently. You want to modify how you output the value Tennessee in this attribute to consistently read as TN.

You do this using a recode table that specifies the original value in one column and the new value in a second column. The recode table looks like this:

Original Value

New Value

TENN

TN

Tenn

TN

Ten

TN

Tn

TN

To recode values

  1. In the Navigation View, click the Discover bar, and click the Entities tab.
  2. Expand the entity that contains the attribute with which you want to work.
  3. Right-click the attribute and select Drill down to metadata. (You can also open the attribute's Summary Data View, and click Attribute Metadata.)

    The List View of attribute metadata displays.

  4. Double-click the row of Values metadata.

    The Values List View displays.

  5. Select rows that contain the Values you want to recode.
  6. Right-click the selection and select Recode values.

    The Recode Values window opens, displaying a list of values selected for recode.

  7. Specify the new value to use for the recode.
    Tell me how…

    You recode values in these ways:

    To…

    Action

    Recode a single value

    1. Double-click the original value in the value column.
    2. Enter the new (recode) value in the to field.
    3. Click OK.
    1. Enter the new (recode) value in the to field.
    2. Click OK.
    1. Click OK.

    Recode multiple values to the same value
    1. Select the values you want to recode.

    To select all valuess, right-click and select Select All.

    1. Right-click and select New.
    2. Enter the new (recode) value. If the new value is one of the existing values you selected, use the drop-down menu to select it.
    3. Click OK.
    1. Enter the new (recode) value. If the new value is one of the existing values you selected, use the drop-down menu to select it.
    2. Click OK.
    1. Click OK.

    Recode values as blanks (NULLs)
    1. Select the values you want to recode as blanks (NULLs).

    To select all the values in the list, right-click and select Select All.

    1. Right-click and select Empty.

    Undo applied recodes
    1. Select those values you want to undo.

    To select all values, right-click and select Select All.

    1. Right-click and select Original.
  8. Click OK.

    Two new columns are added to the attribute's metadata:

    • Value Recode. Displays the value recodes. If the value has not been recoded, the original value is shown.
    • Value Recoded? If the value in the Value Recode column is a recode, this column will display Yes, otherwise it is blank.
    Note: To export value recode look-up tables to use in the Quality Transformer process, see Generating Recode Value Look-Up Tables.

Related concepts
Related tasks