Merge tables

As part of creating or modifying a pattern, you can use the Merge Table operation to merge content from two source tables into a target table.

Before you begin

Navigate to the relevant pattern step:

  1. On the pattern form:
    • Select the relevant identification section for Discovery.

      Or

    • Select the relevant identification or connection section for Service Mapping.
  2. Select the relevant pattern step or click to add a step.

Role required: pd_admin

Basic knowledge of programming is desirable.

About this task

Use this operation to unify information from different sources.

For example, during discovery of connections of IBM WebSphere Portal to IBM WebSphere MQ, you can merge the table containing queue names with the table containing JNDI reference names.

Procedure

  1. Select Merge Table from the Operation list.
  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 To create a table to contain merged data, define the name of the new table.

    To add information from one source table into another, specify the name of the source table to contain merged data.

    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.
  3. To merge tables based on one matching field value:
    1. Click Field matching.
    2. In the First Table Field, enter the value from the first source table.
    3. In the Second Table Field, enter the value from the first source table.
  4. To merge tables based on multiple matching field values:
    1. Click Condition.
    2. In the first condition field, enter the required value.
      For example, enter the actual string or a variable name.

      Define precondition criteria.
    3. Select an operator from the list.
    4. To add more conditions, click the plus icon and define the criteria.
    5. If there are multiple conditions, select All or Any from the Meet list, if they must meet all or any of them.
  5. If in Debug mode, test the step by clicking Test and checking that the operation brings the result you expected.

Example

This operation is used in This item
Hierarchy Applications > Application Servers
CI Type Websphere Portal [cmdb_ci_appl_websphere_portal]
Pattern Websphere Portal On Linux
Section EAR TO MQ Connectivity
Step number and Name 8. Merge the q factories with the jndi ref names

To merge tables containing queue names with JNDI reference names, use the Merge Table operation as follows:


Defining Merge Table operation

What to do next