Use the Character Mapper component window to define mapping rules for data that passes between the IN-port and OUT-port.
The Character Mapper component window includes the:
Current Input Record pane – displays the columns, rows, and content for the record currently at the IN-port.
Current Output Record pane – displays the columns, rows, and content for the current record as it appears to the OUT-port.
Mapping definition pane – includes a From column and a To column.
Creating new mapping definitions
Click the Insert Mapping icon on the toolbar, or right-click anywhere on the Mapping Definition pane, and select Insert Mapping. A new row is inserted for the new mapping definition.
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. See Mapping notations.
Character Mapper applies the rule, and displays the results in the Current Output Record pane
To edit the record currently displayed 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.
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.
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.
