Add a column to a table

Use the Transform table operation to add one or more computed columns to an existing table and place the results in a target table. The target table can be the source table.

Procedure

  1. Select Transform table from the Operation list in one of the following locations:
    • the Identification Sections or Connectivity Sections for Service Mapping
    • the Step window for Discovery
  2. Fill in the fields, as appropriate.
    Field Description
    Source table Specify the name of the source table.
    Target table Specify the name of the target table. The target table can be the same as the source table.
  3. Click the plus icon to add each target field and fill in the fields, as appropriate.
    Field Description
    Target Field Name Specify a name for the column.
    Value Specify the operation expression that determines the values added to the column.

Example

The following configuration is an example of the Transform table operation.
Field Value
Hierarchy Applications > Web Servers
CI Type IIS
Pattern IIS
Section IIS7 and IIS8 Virtual Folder connectivity
Step number and Name 6. remove website name from vpath