Map Import and Export Columns

As your data moves from its source to its target, it passes through a sequence of one or more transforms. You can map input to output columns or view existing mappings in the transform workspace and in the Mapping tab.

A column in a table or extractor is represented by a row in the Input or Output panes. Mapping syntax considerations include the following guidelines:

Extractor names must be enclosed in double quotation marks ("), for example, "0MATERIAL_ATTR_SOP".MATNR.
A hash mark (#) indicates a comment.
A hash mark (#) cannot be included within a mapping expression. It is interpreted as the start of a comment and anything to the right of the hash mark is ignored. A validation error may occur because only part of the script statement (to the left of the hash mark) is validated.

For information about how to sort and filter the names, data types, and descriptions displayed in the lists of inputs and outputs when mapping, see Sorting and Filtering Columns in the Input and Output Panes.

To map input columns to output columns, navigate to a transform in a data flow and do one of the following actions:

Option	Description
Review the current mapping	If a column has already been mapped, the mapping icon appears in the first column of the Output pane. Select a column in the Output pane. The column in the Input pane from which it is mapped is highlighted and the mapping is displayed in the Mapping tab of the Transform Details. A red exclamation point icon indicates that the mapping is invalid or may contain an invalid expression. You can review the mapping in the Mapping tab of the Transform Details.
Create a simple mapping	Drag one or more columns from the Input pane to the Output pane. The mapping icon appears and the column is mapped directly with no changes. Tip In a Target Query, Automap by name is available. Automap by name maps all columns from the Input pane to columns with the same name that exist in the Output pane (target). Automap by name requires that the Input pane contains only one source.
Create a complex mapping	Use function helpers or operators to create a mapping that consists of more than a single input column. Build a function by selecting the function name in the categories in the Mapping tab. For example, you might want to apply the decode function based on the value of an input column: Decode(table1.status_ID = `0`, `NO`, table1.status_ID = `1`, `YES`, `N/A`) Drag one or more columns from the Input pane to the Mapping tab and modify it by applying a function or using operators (`+`,`-`,`*`,`/`,`!=`, and so on). For example, you could use the concatenation operator (`\|\|`) to combine discrete first and last name input columns into a single output column: table1.first_name \|\| ` ` \|\| table1.last_name For more information, see Expression operators.
Add an Output column	In the Output pane, in the bottom row, select the Insert icon and complete the required fields in the dialog box to create a new column. Note You cannot add a column in the Output pane of a Target Query transform. Those columns are defined by the Target table.