Table Recode - Mask - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

This example illustrates table recoding for a mask value. In this example, the Start Date attribute has a variety of data shapes and formats, such as 1/1/2005 and 1/01/2005. Create a recode table to change the mask shapes for the Start Date attribute, so that every Start Date has the format of MM-DD-YYYY. See Using Masks for details.

The table requires a schema such as a DDX that assigns attribute names to the two columns. Create a DDX file that corresponds to the recode table. After creating the recode table and schema, you can specify the Table Recode settings.

Below are the settings for the Start Date attribute:

File Qualifier TBL2
Table File Name datamask.csv
Table DDL File Name datamask.ddx
File Delimiter Comma
Lookup Table Fields Original Mask
Lookup Output Fields Start Date
Lookup Output Fields Format Mask
Recode Table Fields Recode Mask
Recode Table Fields Format Mask
Recoce Output Fields Start Date

The settings would look like these in the Table Recode section window:

These settings tell the Transformer to scan the Start Date attribute for Mask, and recode the value according to the recode table (datamask.csv). After running the Transformer, every Start Date will have the format of MM-DD-YY.