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.
Column Comparator
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.
Dialog Options
- Column Left
- Left column selected for comparison.
- Column Right
- Right column selected for comparison.
- Operator
- 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.
Ports
Output Ports
0 |
Input data plus comparison column |
This node is contained in KNIME Base Nodes
provided by KNIME GmbH, Konstanz, Germany.