Select Columns Screen (Magic xpi 4.13)
The Select Columns screen provides a list of database columns. Select the columns to use for mapping your data. The columns look different depending on whether the database you are mapping is a Source or a Database.
Follow these steps to use this screen:
-
Select a database column from the Available Columns field on the left side of the screen. To add multiple columns, select a database name.
-
Click the Add button to move the selected column or columns to the Selected Columns field. You can also double-click on a column or database name in the Available Columns field to move the columns into the Selected Columns field.
-
To remove a column from the Selected columns field, select a column and click the Remove button. You can also double-click on a column in the Selected Columns field to move it back to the Available Columns field.
-
To remove multiple columns, stand on the table name and click Remove.
|
|
-
If you add columns to a table and the table is not in the range of the Filter Tables or the Starting Owner list (if this is so, then the first screen before the Tables in the wizard is the Database Definition Non-Supported Tables screen), then the columns are not re-fetched and the new columns will not be seen unless the table is re-selected.
-
If the column name contains a space, the name needs to be enclosed by square brackets in the last screen of the wizard, where the SQL statement is displayed.
-
Two columns with the same name, but which are in different tables, cannot be mapped to a Destination. In this situation, you should add an alias to one of the table names.
|
-
When you have selected the columns, click Next to display the WHERE clause screen.
The Select Columns screen contains the following additional field:
|
|
|
|
Display Field Order
|
The wizard's next screen displays a list of database fields. The Display Field Order drop-down list lets you select the order in which the fields are displayed, either Database Order or Alphabetical Order.
|
