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.
Options
Views
- This node has no views
Workflows
00_Combine_Clean_and_Summarize_Spreadsheet_DataKNIME Hub- 01_Fault_Tolerant_Workflow_OrchestrationKNIME Hub
- 01_Fault_Tolerant_Workflow_OrchestrationKNIME Hub
- 01_Preprocessing_Time_Alignment_and_VisualizationKNIME Hub
- 01_Preprocessing_Time_Alignment_and_VisualizationKNIME Hub
- Show all 107 workflows
Links
- Replace specific rows values considering the value condition of another columnby s.roughley on 2018-05-12forum.knime.com/p/42587
- Join creates new columns instead of joining themby armingrudd on 2020-04-16forum.knime.com/p/87789
- Using List Files Node to create a Variable for Updating a Column in a Joinby DavisRogers on 2019-10-04forum.knime.com/p/71748
- Merge two columns of a table togetherby armingrudd on 2022-03-06forum.knime.com/p/149906
Developers
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.