Mapping Fields Automatically
You can automatically map the target fields with the source by name or by position. Matching always begins in the first target field. Match by Name looks for a field in the target that has the same name as the source (case insensitive) and maps the target field with the source if it finds the field. Match by position walks down the rows of target fields and maps the target field 1 to source field 1, target field 2 to source field 2, and so on.
To map fields by name, do any of the following:
• Click
and select
Match by Name.
• Right-click on the target connection section and select Match by Name.
To map fields by position, do any of the following:
• Click
and select
Match by Position.
• Right-click on the target connection section and select Match by Position.
Note: You cannot undo these actions from Edit > Undo Match by Name or Edit > Undo Match by Position, respectively.
The Expression column populates the appropriate field name (matching with source name). The fields in the source and target are re-arranged based on the selected mapping option.
If you have already modified a field, it is not overwritten when the fields are automatically mapped.
Other ways to map target fields:
• Map a target field to a constant (that is, type ="3") in the target Expression column.
• Map a target field to a different target field by dragging a target field name and dropping it on a different target field's expression.
• Map a target field to the result of a complex expression or a function contained in a Script Library (click
and use expression builder).
• Map a target field to a global variable (type =globalvariablename in the Expression column OR use the expression builder).