Lookup Table configuration example

This example shows how to configure a data lookup table. You enter the conversions in the table and save to a file. Then, you can use the table in a record translation specification to convert the input data to the output data.

  1. Select File > Set Password, and specify a password.
  2. Click New Append.
  3. In the Table Entry pane, specify the first input data value in the In field.
  4. Press Tab to go to the next field.
  5. Specify the corresponding output data value in the Out field.
  6. Press Tab to begin a new line.
  7. Repeat steps 5-6 until all input and output data values are entered.
    You can also use the arrow keys to move among the fields.
    To add fields, use Tab or New After/New Before.
  8. In the Table Control Values pane, specify No Action as the default value and select Set Default Value as Masked Field.
  9. Click Save. This opens a file selection dialog box in which to save the table.
  10. Specify a file name and save.