Union

Contents[Hide]

The Union transform combines data from multiple structures by mapping columns onto one another. If the structures come from the same data connector, and the data provider supports union statements, then an optimized query will be generated and sent to the server.

Transform - Union
Transform - Union

1. Input

The Union transform requires 2 input transforms.

For example, the input could be data coming from 2 different Excel worksheets:

2. Configure

In the Union configuration dialog, you must configure the following settings:

  1. Inputs

    Select the first table and choose elements to be used in this transform.

    Union configuration dialog - Union Transform Primary Input
    Union configuration dialog - Union Transform Primary Input

    You need to setup column mapping if any of the column names from Input Table 2 does not match with the column names from Input Table 1. In this sample, Region does not match with Rgn and Sales does not match with Sales Amount, so mapping should be added for both columns:

    Input Table 2: Sales_2014 (different column names)
    Input Table 2: Sales_2014 (different column names)

    Map the columns between the 2 tables. Select Input Table 2 on the Inputs dropdown:

  2. Include Duplicate Rows

    Duplicate rows are included by default. If set to false, removes any duplicate rows.

    Include Duplicate Rows.
    Include Duplicate Rows.

3. Output

The output of the Union transform consists of combined rows from the 2 inputs.

The figure below illustrates the output from the Union transform:

Union output example
Union output example

 

The figure below illustrates the output when the duplicate rows are excluded:

Duplicate row(s) are removed
Duplicate row(s) are removed

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri