Create a Column Map

This section explains how to create a Column Map from the main window or the Column Map Editor.

From the Main Window: Move or Archive

To create a Column Map for Move or Archive:

  1. In the main window, select New from the File menu.
  2. Select Column Map from the Definitions submenu to open the New Column Map dialog.
  3. For Validation Rules, select Move/Archive.
  4. 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.
  5. Specify the name of the destination table containing the columns you want to map.
  6. Click OK to open the Column Map Editor.
  7. Modify the Source Column names, as needed.
  8. Select Save from the File menu to open the Save the Column Map dialog.
  9. 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.

From the Main Window: Compare

To create a Column Map for Compare:

  1. In the main window, select New from the File menu.
  2. Select Column Map from the Definitions submenu to open the New Column Map dialog.
  3. For Validation Rules, select Compare.
  4. Specify the name of the table containing the columns you want to map in each source:
    • 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.
  5. Click OK to open the Column Map Editor.
  6. Choose Source 1 column names to map, as needed, by clicking on the column name and selecting from the list of columns available.
  7. Select Save from the File menu to open the Save the Column Map dialog.
  8. In the Pattern box, specify a unique Column Map name and then click Save.

From the Column Map Editor

To create a Column Map:

  1. In the main window, select Column Map from the Definitions menu to open the Column Map Editorand last edited Column Map.
  2. Your next step depends on your purpose:
    • To create a new Column Map, select New from the File menu in the Column Map Editor to open the New Column Map dialog. Specify the source/destination tables OR Source1/Source 2 tables, and click OK to open the Column Map Editor.
    • To create a new Column Map modeled on an existing one, open the desired Column Map and select Save As from the File menu in the Column Map Editor.
    • To create and store a copy of the active Column Map and continue editing, select Save Copy As from the File menu in the Column Map Editor.
Note: Pseudocolumns for attached files are automatically displayed in a Compare Column Map when Source 2 includes attached files. If Source 1 pseudocolumns are not displayed automatically, you can select them as Source 1 columns.

These steps are the minimum required to create a Column Map. The steps to edit a new Column Map or existing Column Map are similar. See Using the Editor for details.

In addition, you can open the Column Map Editor from the Tools menu in the Convert Request Editor, Insert Request Editor, or Load Request Editor. For details, refer to the appropriate chapter in the corresponding user manual.