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
-
Recode masks for an attribute. See Recoding masks.
-
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.
-
Right-click any row in the List View and select Export as
Recodes….
The Export Recodes in Trillium format window opens.
-
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.
- Default directory
-
Windows: C:\ProgramData\Trillium Software\MBSW\17\Data\export
- For Export, verify that Masks is selected.
- For Field Width, choose either Auto or Select.
-
Explain options…
-
|
Option
|
Description
|
|
Auto
|
If selected, the default field length will be twice the length of the longest mask
|
|
Select
|
If selected, specify a required length up to 100 bytes.
|
- For Encoding, select an encoding option.
-
Click OK.
-
Click Now to generate the recode table. (Click Later schedule a date and time to run the job.)
-
(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.