Merge tables

Use the Merge table operation to merge content from two source tables into a target table.

About this task

You can specify the following type of criteria:

  • Field equality: If they have matching values in specified fields, both source tables are merged.
  • Condition: If they both satisfy the criteria, both source tables are merged.

Procedure

  1. Select Merge 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
    First table Specify the name of the first source table.
    Second table Specify the name of the second source table.
    Target table Specify the name of the target table.
    Unmatched values For tables that meet the merge criteria, select an action from the list for unmatched rows:
    • Keep: If merge criteria is met for any row, it merges all rows from both source tables into the target table.
    • Remove: Merges only matching rows from both source tables into the target table, and excludes non-matching rows.
    Merge Criteria Select a merge type from the list:
    • Field equality: Merge based on fields that have matching values. Specify fields in the tables to be compared.
    • Condition: Merge based on certain criteria being met. Use the condition builder to specify the criteria.

Example

The following configuration is an example of the Merge table operation.
Field Value
Hierarchy Applications > Application Servers
CI Type WebSphere EAR
Pattern J2EE EAR On Linux
Section DB2 JDBC connectivity
Step number and Name 21. merge the scanned_result with outgoing_conns