Skip to main content

Union

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

Union

Example: Union package

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 the specified common field or fields between the entities. Use Swap 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.

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

Source: Client_B

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