Drag & drop to use
Drag & drop this node right into the Workflow Editor of KNIME Analytics Platform (4.x or higher).Learn more
Merges two columns into one by choosing the cell that is non-missing. The configuration dialog allows you to choose a primary and a secondary column. The output of the node will be a new column (or a replacement of the selected input columns), whereby the output value for each row will be
Note that the output value might be missing if and only if the secondary column contains a missing value. Also note that the type of the output column is a super type of both selected inputs, i.e. if you choose to merge a number and a string column, the output column will have a very general data type.