0 ×

Column Comparator

StreamableKNIME Base Nodes version 4.4.0.v202106241539 by KNIME AG, Zurich, Switzerland

Compares the cell values of two selected columns row-wise. A number of different comparison methods are available: equal, not_equal, less, greater, less_equal, and greater_equal. A new column is appended holding either the left or right column value, a missing cell, or a user specified tag. The type of the appended column depends on the selected content: If a user defined tag is selected, the result column is of type string, in all other case the type is determined by the type of the selected columns.


Column Left
Left column selected for comparison.
Column Right
Right column selected for comparison.
Comparison is done based on the selected operator option: equal, not_equal, less, greater, less_equal, or greater_equal
Replacement Method
Depending on the result of the selected operator, a certain value is set into the new column. Select one of the following options for the operator result 'true' and 'false': LEFT_VALUE - the value of the left column is set in the result column. RIGHT_VALUE - the value of the selected right column is used. MISSING - a missing cell is set in the result column. USER_DEFINED - the text entered in the corresponding 'Tag' field is set in the result column.
New Column
Name of the new appended column.

Input Ports

Arbitrary input data.

Output Ports

Input data plus comparison column

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME Base nodes from the following update site:


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

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


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.