You can generate and export recoded masks and values as look-up tables that can be used by the Trillium Quality Transformer process for recoding data formats such as time, dates, names, and addresses. The recode tables are exported to the /export directory on the repository server system (C:\Program Data\Trillium Software\MBSW\17.1\Data\export).
Note the following guidelines:
- Recode tables include only records for masks or values that were actually recoded. If there are masks or values that remained unchanged, these are not included in the output file.
- All mask or value recodes for an attribute are exported together to be included in the look-up table.
- The export process saves two files to the export location: a .CSV file listing the recodes and original values, and a .DDX schema file, required by the Quality Transformer process.
To generate and export a mask or value recode look-up table
-
Recode values or masks for an attribute. See Recoding Data Values and Recoding Masks.
-
Navigate to one of the following tab views:
- A Values tab that includes the Value Recode and/or the Recode Mask columns, added when a value or mask in the attribute was recoded. The values in these columns will be included in the recode export.
- A Masks Values tab that includes the Recode Mask column. added when a mask in the attribute was recoded. The values in this column will be included in the recode export.
-
Click Export > Export Mask Recodes or Export Value Recodes, depending on the recodes you want to export. The Export Value Recodes or Export Mask Recodes window opens.
-
For Field Width, select one of the following:
|
Option
|
Description
|
|
Auto
|
The default field length will be twice the length of the longest mask.
|
|
Enter Width
|
Enter or select a byte width value from 1 to 100. Decimals are not supported.
|
-
For Encoding, select the code page you want used on the exported files. The default is Server Native.
-
For File Name, enter a name (required). Enter a unique name; otherwise any recode file with the same name in the
/export directory will be overwritten. Do not include any of the following invalid characters in the file name: \ / : * ? " < > |
-
Click Export. A confirmation message opens.
-
Click OK to close the message.
-
(Optional) View the details of the export job in the Task Manager.
-
(Optional) To verify the export, navigate to the repository export directory and open the export file with a text editor like Notepad or WordPad.