Column Merger


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

  • the value in the primary column if it is not missing,
  • the value in the secondary column otherwise.

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.

Input Ports

  1. Type: Data Input with two columns to merge.

Output Ports

  1. Type: Data Input along with the merged column.

Find here

Manipulation > Column > Split & Combine

Make sure to have this extension installed: