Use the Column Map Editor to create a Column Map.
When you create a new Column Map, Optim populates the
grid automatically on the basis of your selections in the New Column
Map dialog. You edit the values in the first grid column to map columns.
The names of the tables, for which columns are mapped, are displayed
at the top of the Column Map Editor.
- In the main window, select Column
Map from the Definitions menu. The New Column Map dialog opens.
- From the Validation Rules area,
select Move/Archive.
- Specify the name of the source table containing
the columns you want to map:
- If you select the File option,
supply the file name and specify the name of a table in that file.
- If you select the Database option,
supply the name of the database table.
- Specify the name of the destination table
containing the columns you want to map.
- Click OK to open the Column
Map Editor.
- Modify the Source Column names, as needed.
- Select Save from the File menu
to open the Save the Column Map dialog.
- In the Pattern box,
specify a unique Column Map name and then click Save.
Note: The pseudocolumns that represent attached files do not
appear in a Move or Archive Column Map. However, the pseudocolumns
can be mapped as source columns and will be used whether or not file
attachments are processed.