The Transformer’s Table Recoding function converts the values in an attribute using an external user-defined recode table. You can recode literal or mask values.
Specify table recode settings with the Table Recode Wizard
To specify table recode settings with the Table Recode Wizard
- Create a user-defined external recode table. You can create a recode table in any text editor. The recode table can be a delimited file or fixed length file. If delimited, one column on the left is for the original value and a second column on the right is for the recoded value.
- From the Navigation or Project View, right-click the special Transformer process and select Edit Process.You can also double-click the process to open it for editing.
- Select the Output Conditionals tab.
- Click the Edit Table Recodes button. The Table Recode section window opens.
- Click the Add Table Recode button. See Recoding Data Using Tables to specify the settings with the wizard.
- Click Finish to save the changes.
Specify table recode settings manually
To specify table recode settings manually
You can specify the Table Recode settings manually only for the special Transformers.
Delete table recode settings
To delete table recode settings
When you delete the Table Recode settings, make sure to delete only the ENTRY section of the parameter.