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: On the pattern form: Select the relevant identification section for Discovery.Or Select the relevant identification or connection section for Service Mapping. 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 Select Merge Table from the Operation list. 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. To merge tables based on one matching field value: Click Field matching. In the First Table Field, enter the value from the first source table. In the Second Table Field, enter the value from the second source table. To merge tables based on multiple matching field values: Click Condition. In the first condition field, enter the required value. For example, enter the actual string or a variable name. You can use variables including values from tabular variables as described in Enter values and variables in patterns. Select an operator from the list. To add more conditions, click the plus icon and define the criteria. If there are multiple conditions, select All or Any from the Meet list, if they must meet all or any of them. 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: What to do next Continue editing the pattern by adding a new step and defining its operation or Finalize the pattern.