Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Append two tables

Append two tables

As part of creating or modifying a discovery pattern, you can use the Union table operation to append two tables of the same format.

Before you begin

Navigate to the relevant pattern step:

  1. On the pattern form, select the relevant identification section for Discovery.

    Alternatively, select the relevant identification or connection section for Service Mapping.

  2. Select the relevant pattern step or click to add a step.

Basic knowledge of programming is desirable.

Role required: pd_admin

About this task

Appending two tables adds the second table at the end of the first table and places the results in the additional, target table. If necessary, you can specify one of the source tables as the target table.


  1. Select Union Tables 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 Specify the name of the table into which the results are placed.
  3. If in Debug mode, test the step by clicking Test and checking that the operation brings the result you expected.


This operation is used in This item
Hierarchy Applications > Application Servers
CI Type WebSphere EAR
Pattern J2EE EAR on Linux
Section Oracle JDBC connectivity
Step number and Name 5. Union JDBCProviders with JDBCProviders2

A WebSphere EAR on Linux has two tables containing data on JDBC Providers. To add data from the second table at the bottom of the first table, use the Union Tables operation as follows:

Defining Union Tables operation

What to do next

Changes to site functionality will be made starting around 6am on January 21st (Pacific Time) and lasting approximately 6 hours.  The site may be intermittently unavailable.