Set Operator

Performs set operations on two table columns. The available set operations are:

  1. Intersection
  2. Union
  3. Complement
  4. Exclusive-or

Options

First set
The column of the first data input table which contains the elements of the first set.
Operation
The set operation to perform on the selected sets.
  • Intersection: The intersection of the two sets.
  • Union: The union of the two sets.
  • Complement: The complement of the second set to the first set.
  • Exclusive-or: The symmetric difference of the two sets.
Second set
The column of the second data input table which contains the elements of the second set.
Skip missing values
All missing values will be skipped during computation thus the result set contains no missing value elements.
Enable hiliting
If enabled, the hiliting of a set entry row will hilite all rows of this set entry in other views. Depending on the number of rows, enabling this feature might consume a lot of memory.

Input Ports

Icon
Contains the column whose values are used as the first set.
Icon
Contains the column whose values are used as the second set.

Output Ports

Icon
The output table contains a single column with the result of the set operation.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

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, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.12

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 5.12.0.v202606261225
On NodePit since: 2026-08-08
Last update: 2026-08-12
Tags: Modern UI
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!