Union

Outputs the Union of two relations (tables). Optionally it outputs the result of a set operation obtained by the combination of Union with Not.

Options

Union
Merges two relations, removing duplicate tuples (rows).
Minus
Keeps tuples in the left (top) relation that do not occur in the second.
Intersect
Keeps only tuples that occur in both relations.
Difference
Keeps only tuples that occur in one relation or the other but not both.

Input Ports

Icon
The left (top) input relation.
Icon
The right (bottom) input relation.

Output Ports

Icon
The result of the Union or other set operation.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, download the below referenced file, save it to your KNIME's plugin folder and restart KNIME.

v5.4
Plugin provider: andl
Plugin version: 1.0.0.202004072326
On NodePit since: 2024-12-06
Last update: 2025-05-07
KNIME versions: Since v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!