Suppose you have created a set of map variables for an Insert operation but decide to change from one database table to another. You can keep the previously defined mapped variables intact.
For this example, the Insert operation was selected from the Action drop-down list. It is assumed that you have created a set of map variables and they appear on the Input tab.
The Insert tab shows the current table column names and other meta data.
To retain the map variables when changing to another database table, follow these steps:
- From To Enterprise section, click
the Table down-arrow.
A list of tables appears.
- Select the table that you want to change to.
The Insert tab changes to accommodate the new table.
At this point, the Variable column is empty. - Click Map Table.
The Map Table window appears.
- To keep the existing map variables, click No.
If you click Yes, the current map
variables on the Input tab are
removed.
The new variables are created and added to the
Variable column on the
Insert tab.
A new set of map variables appear on the
Input tab along with the existing map
variables.
From the Insert tab, you can associate
whatever map variables you want with the map variables on
the Input tab.
You can also remove the map variables that do not want to
keep.
- From the Input tab, select the map
variable that you want to remove, display its pop-up
menu, and then click Clear.
- If you click Clear All, all the map variables are removed from the Input tab. You can click MapTable to create another set of map variables.
The map variable is removed from the Input tab.