The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Set Operator

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

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

Dialog 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.
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 none missing value elements.
Sort in memory
Performs necessary sorting in the memory. Speeds up the process but consumes much more memory.
Enable hiliting
If enabled, the hiliting of a set entry row will hilite all rows of this set entry in other views. Depending of the number of rows, enabling this feature might consume a lot of memory.

Ports

Input Ports
0 Set one
1 Set two
Output Ports
0 Result set
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.