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.

Options

Left column

Left column selected for comparison.

Operator

Comparison is done based on the selected operator option.

• Equals: Tests if both cell values are equal.
• Not equals to: Tests if both cell values are not equal.
• Less than: Tests if the left cell value is less than the right cell value.
• Less or equal than: Tests if the left cell value is less than or equal to the right cell value.
• Greater than: Tests if the left cell value is greater than the right cell value.
• Greater or equal than: Tests if the left cell value is greater than or equal to the right cell value.

Right column

Right column selected for comparison.

Operator result 'true'

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'.

• Left value: The value of the left column is set in the result column.
• Right value: The value of the right column is set in the result column.
• Missing: A missing cell is set in the result column.
• User-defined: The text entered in the 'Tag' field is set in the result column.

Tag

The text to set in the result column when the operator result is 'true'.

Operator result 'false'

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 'false'.

• Left value: The value of the left column is set in the result column.
• Right value: The value of the right column is set in the result column.
• Missing: A missing cell is set in the result column.
• User-defined: The text entered in the 'Tag' field is set in the result column.

Tag

The text to set in the result column when the operator result is 'false'.

Output column name

Name of the output column.

Views

This node has no views

Workflows

• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• Show all 87 workflows

Links

• No links available

Developers