Skip to main content

Union

Union creates an entity where two entities are added together to create one target —both entities must share the same field names, field counts, and data types .

Union controller

Example: Union package

Example of a union dataflow uniting two entities

Once entities are added to the canvas, the Union package is brought onto the canvas by double-clicking or dragging the icon.

When the square icon becomes a live controller on the canvas, connect entity 1 and entity 2 outputs to the Union control INPUT 1 and INPUT 2.

The example below shows a simple union where the data has been merged into the same fields. Union merges two identically structured entities (identical field names, number of fields, data type) into one table whereas Join combines columns in one result set based on a specified common field or fields between the entities. Use Swap function in Union controls to reverse INPUT 1 and INPUT 2 so that for the example 'Client_B' will connect to INPUT 1 and 'Client_A' will connect to INPUT 2.

Swap function is located on top left of input section in union control

Union transform creates a united entity with identical fields

The following shows sample data for both entities (Client_A, Client_B) and target entity sample data (Client_AB_Union)

Source and target entities—Union transformation

Source: Client_A

Sample data displays records of source entity A records numbered 1 through 10

Source: Client_B

Sample data displays records of source entity B records numbered 11 through 20

Union: Returned a target entity merging 'Client_A' (10 records) with 'Client_B' (10 records) to create 'Client_AB_Union' (20 records).

Sample data displays records of target entity AB records numbered 1 through 20