Creating New Mapping Definitions

Use the Character Mapper component window to define mapping rules for data that passes between the input port and output port.

1. Click the Insert Mapping icon on the toolbar, or right-click anywhere on the Mapping Definition pane, and select Insert Mapping.
2. Enter the character combination you want to replace in the From column, and the value with which you want to replace it in the To column.
   Character Mapper applies the rule, and displays the results in the Current Output Record pane.

   • To edit the record currently shown in the Current Input Record pane, click a row in the Current Input Port Content pane and make changes. The values in the Current Output Record pane and the selected row in the Current Outport Port pane are also updated.

   • To delete a mapping definition, right-click the mapping definition and select Remove Mapping.

   • To change the order of the mapping definitions, select the Move row up and Move row down icons on the toolbar.

3. Character Mapper applies the mapping, and updates the output results as soon as you write the rule. Click the Enable auto refresh of output values icon on the toolbar to toggle this kind of automatic synchronization.
   Note:

   Character Mapper applies mappings to all columns and all rows. To exclude columns from a character mapping, click Exclude in the Properties window, and select the columns you want to exclude.