Merge tables

You can 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: Both source tables are merged if they have matching values in specified fields.
  • Condition: Both source tables are merged if they both satisfy the criteria.

Procedure

  1. On the Identification or Connectivity Sections form, select Merge table from the Operation list.

    Defining parameters and conditions for the table merge operation.
  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: Merges all rows from both source tables into the target table if merge criteria is met for any row.
    • 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

What to do next

Finalize a pattern