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.