Generating Recode Mask Look-Up Tables - 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

You can generate and export recoded masks as a physical file and configure the TS Quality Transformer functions to use it as a look-up table for recoding data formats such as times, dates, names, and addresses.

Note the following:

  • The export process saves two files to the export location: a file listing the recodes and original values and a .ddx file containing XML of the recode.
  • By default all recodes for an attribute are exported together to be included in the mask look-up table.
  • The recode table includes only records for masks that were actually recoded. If there are masks that remained unchanged, these are not included in the output file.
  • If the Transformer is unable to find a mask in the look-up table, it leaves the mask unchanged.

To generate a recode mask look-up table

  1. Recode masks for an attribute. See Recoding masks
  2. Examine the two new columns in the attribute's Mask List View: Recoding mask and mask Recoded?. These are the values that will be exported to a recode mask look-up table.
  3. Right-click any row in the List View and select Export as Recodes….

    The Export Recodes in Trillium format window opens.

  4. Enter the following information:
    • In File field, enter a unique name for the output file. The file will be saved to the default repository export directory unless you specify a different directory.
    Note: If you do not specify a name, the file will not be saved.
    • For Export, verify that Masks is selected.
    • For Field Width, choose either Auto or Select.
    • For Encoding, select an encoding option.
  5. Click OK.
  6. Click Now to generate the recode table. (Click Later schedule a date and time to run the job.)
  7. (Optional) To verify the export, navigate to the repository export directory on your system and open the export file with a text editor like Notepad or WordPad.
    Note: If the file was not exported, run the process again ensuring to enter a unique name for the file.