Load Table - Map Columns

Use this page to map the columns between the selected table and an external table from which you are loading data.

Columns for Table target table

This list displays the columns in the target table. The target table is the selected table.

Columns for Table source table

This list displays the columns in the source table. The source table is the external table from which you are loading data. Select a column in the source table to map to the column in the target table.

Filters

The list displays any filters applied to the column. Click the plus button to add a filter for the column. Filters specify which data from the source table is loaded into the target table. For example, if you add the filter call_code = 03, only the rows with a value of 3 are loaded.

Enter query criteria

Use this page to define the filter for the column. Select an operator from the list of operators, enter a value, and click Add. The load criterion is displayed in the table.

Auto Map

Click to map any columns that have the same name in the target table and the source table.

Reset

Click to clear any mapped columns.