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
Popular Predecessors
- Joiner12 %
- Column Merger12 %
- Concatenate6 %
- Rule Engine4 %
- Column Filter3 %
- Excel Reader3 %
Cell Splitter2 %- String Manipulation2 %
Row Filter (deprecated)2 %- Cell Splitter2 %
String To Number2 %Column Rename2 %- String to Number2 %
- Column Renamer2 %
- Math Formula1 %
- Column Resorter1 %
- GroupBy1 %
- Column Combiner1 %
- Duplicate Row Filter1 %
- Number to String1 %
- Constant Value Column< 1 %
- Column Appender< 1 %
- Column Expressions< 1 %
- CSV Reader< 1 %
- Missing Value< 1 %
- Value Lookup< 1 %
- Table Creator< 1 %
- String Manipulation (Multi Column)< 1 %
Cell Replacer< 1 %Joiner< 1 %- Rule-based Row Filter< 1 %
Row Splitter (deprecated)< 1 %Excel Reader (XLS)< 1 %- Column Aggregator< 1 %
- Loop End< 1 %
- Cross Joiner< 1 %
Table Row To Variable Loop Start< 1 %- String Replacer< 1 %
- Random Forest Predictor< 1 %
Table Row to Variable< 1 %- Sorter< 1 %
- Table Manipulator< 1 %
- Column Auto Type Cast< 1 %
- String Splitter (Regex)< 1 %
Excel Reader (XLS)< 1 %- Value Counter< 1 %
XLS Reader< 1 %- String to Date&Time< 1 %
Variable to Table Column< 1 %- Date&Time Part Extractor< 1 %
Variable to Table Column< 1 %- Table Transposer< 1 %
Database Connection Table Reader< 1 %- Column Splitter< 1 %
- Counter Generation< 1 %
CSV Reader< 1 %- Reference Row Filter< 1 %
- Pivot< 1 %
- String Manipulation (Variable)< 1 %
- DB Query Reader< 1 %
Table Column to Variable< 1 %File Reader< 1 %Loop End< 1 %- Decision Tree Predictor< 1 %
Merge Variables< 1 %- Integer Configuration< 1 %
- RowID< 1 %
- Google Sheets Reader< 1 %
- Auto-Binner< 1 %
- Column Comparator< 1 %
- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- Column to Grid< 1 %
- Nominal Value Row Filter< 1 %
- SDF Extractor< 1 %
- Table View (JavaScript)< 1 %
- Excel Writer< 1 %
- Java Snippet< 1 %
- Column List Loop Start< 1 %
- One to Many< 1 %
- Rule-based Row Splitter< 1 %
- IF Switch< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Create Collection Column< 1 %
- DB Reader< 1 %
- Variable to Table Row< 1 %
- Table Validator< 1 %
- Scatter Plot (JavaScript)< 1 %
- List Files/Folders< 1 %
- Case Converter< 1 %
String Replace (Dictionary)< 1 %- Ungroup< 1 %
- Document Data Extractor< 1 %
- Date&Time to String< 1 %
- Create Date&Time Range< 1 %
- Date&Time Shift< 1 %
- Try (Data Ports)< 1 %
- Column Selection Configuration< 1 %
- Modify Date< 1 %
Variable to Table Row< 1 %Scorer< 1 %- Cell Splitter By Position< 1 %
- Unpivot< 1 %
- Rule Engine (Dictionary)< 1 %
- Statistics< 1 %
- Column Filter (legacy)< 1 %
- Date&Time Difference< 1 %
Extract Date&Time Fields< 1 %- Table Validator (Reference)< 1 %
- Constant Value Column Filter< 1 %
- Missing Value (Apply)< 1 %
- JSON Path< 1 %
Python Script (1⇒1)< 1 %- Date&Time-based Row Filter< 1 %
- RDKit Canon SMILES< 1 %
Regex Extractor< 1 %- Variable to Table Column< 1 %
- Table Reader< 1 %
- Recursive Loop Start< 1 %
- Merge Variables< 1 %
- Path to String< 1 %
- Row to Column Names< 1 %
- Split Collection Column< 1 %
- Loop End (Column Append)< 1 %
- Group Loop Start< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Regression Predictor< 1 %
- Category to Number< 1 %
Number To String< 1 %- Column Renamer (Dictionary)< 1 %
- Lag Column< 1 %
Linear Correlation< 1 %- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Number Rounder< 1 %
- Set Operator< 1 %
- End IF< 1 %
- SDF Reader< 1 %
- Math Formula (Multi Column)< 1 %
- Line Plot (JavaScript)< 1 %
- JSON to Table< 1 %
- R Snippet< 1 %
- ARFF Reader< 1 %
Recursive Loop End< 1 %- Domain Calculator< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Extract Table Spec< 1 %
- Conditional Box Plot (legacy)< 1 %
- Tags to String< 1 %
- Date&Time to legacy Date&Time< 1 %
- Modify Time< 1 %
- Remove Empty Rows< 1 %
- Table Column to Variable< 1 %
- Table Row to Variable< 1 %
- File Reader< 1 %
- Table Row to Variable Loop Start< 1 %
- DB Writer< 1 %
- Read Excel Sheet Names< 1 %
- Python Script (legacy)< 1 %
Database Delete< 1 %Naive Bayes Predictor< 1 %- Add Empty Rows< 1 %
Column Appender< 1 %- Data Generator< 1 %
- TF< 1 %
- String to Date/Time (legacy)< 1 %
- XPath< 1 %
- String to URI< 1 %
Table Reader< 1 %- Naive Bayes Predictor< 1 %
- Perl Scripting< 1 %
- Extract Missing Value Cause< 1 %
- String to Number (PMML)< 1 %
- RDKit Descriptor Calculation< 1 %
- Entropy Scorer< 1 %
- Reference Column Splitter< 1 %
- DB Connection Closer< 1 %
- RDKit Substructure Counter< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Create Bit Vector< 1 %
- One to Many (PMML)< 1 %
- Empty Table Switch< 1 %
- Java Snippet (simple)< 1 %
Python Script (2⇒1)< 1 %- RDKit From InChI< 1 %
- Fingerprint From String< 1 %
- Active Branch Inverter< 1 %
- Hierarchical Clustering< 1 %
- Numeric Binner< 1 %
- Filter Apply Row Splitter< 1 %
- Rank< 1 %
- DB Merge< 1 %
- Gaussian Distributed Assigner< 1 %
- Math Formula (Variable)< 1 %
- Bag Of Words Creator< 1 %
- Term to String< 1 %
- Table Editor (JavaScript)< 1 %
- File Reader (Complex Format)< 1 %
Loop End (2 ports)< 1 %- Files/Folders Meta Info< 1 %
- Catch Errors (Data Ports)< 1 %
Gradient Boosted Trees Predictor< 1 %Random Forest Predictor< 1 %- Random Forest Predictor (Regression)< 1 %
- Many to One< 1 %
- Molecule Type Cast< 1 %
- OpenBabel< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Reader (XLS)< 1 %- Term Co-Occurrence Counter< 1 %
- RegEx Filter< 1 %
- JSON Row Combiner< 1 %
- Time Difference (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Fingerprint From Binary String< 1 %
- pKa< 1 %
- File Meta Info (legacy)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %- Image to Table< 1 %
Line Reader< 1 %Recursive Loop Start (2 ports)< 1 %Variable Loop End< 1 %- Polynomial Regression Learner< 1 %
- Category to Number (Apply)< 1 %
Number To String (PMML)< 1 %- Reference Column Resorter< 1 %
- Top k Row Filter< 1 %
- Voting Loop End< 1 %
- Variable Expressions< 1 %
- H2O to Table< 1 %
- SAS7BDAT Reader< 1 %
- Inverter< 1 %
- Time Field Extractor (legacy)< 1 %
Table to HTML String< 1 %- URL Domain Extractor< 1 %
Table Column to Variable< 1 %- K Nearest Neighbor< 1 %
- Numeric Scorer< 1 %
- Distance Matrix Calculate< 1 %
- Number Filter< 1 %
- Anonymization< 1 %
- Speedy SMILES Element Count (C, N, O)< 1 %
IF Switch (Flow Variable Value)< 1 %- InfluxDBConnector< 1 %
Database Reader< 1 %- Fixed Width File Reader< 1 %
List Files< 1 %Counting Loop Start< 1 %- Chunk Loop Start< 1 %
Recursive Loop End (2 ports)< 1 %Recursive Loop Start< 1 %Concatenate (Optional in)< 1 %- Binner (Dictionary)< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- Row Sampling< 1 %
- Color Manager< 1 %
- ROC Curve (legacy)< 1 %
- Parallel Chunk End< 1 %
PMML Predictor< 1 %- Columns to JSON< 1 %
Python Script (1⇒1)< 1 %- R to Table< 1 %
- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Time to String (legacy)< 1 %
- Discretise< 1 %
- RDKit Aromatizer< 1 %
- RDKit From Molecule< 1 %
- RDKit To Molecule< 1 %
- RDKit Salt Stripper< 1 %
- Duplicate Filter< 1 %
- Canonical SMILES< 1 %
- InChi< 1 %
- LDB Reader< 1 %
- Table Merger< 1 %
- Random Numbers Generator< 1 %
- Number Formatter< 1 %
Python Snippet< 1 %- Refractivity< 1 %
- Pareto Ranking< 1 %
- Strings to Binary Objects< 1 %
- Unzip Files (legacy)< 1 %
- Inject Variables (Data)< 1 %
Line Reader< 1 %- Java Edit Variable< 1 %
- Feature Selection Filter< 1 %
Generic Loop Start< 1 %- X-Aggregator< 1 %
- PNN Predictor< 1 %
- k-Means< 1 %
PCA Apply< 1 %Regression Predictor< 1 %- Association Rule Learner< 1 %
Gradient Boosted Trees Predictor< 1 %- PMML Gradient Boosted Trees Predictor (Regression)< 1 %
- Expand Bit Vector< 1 %
- Correlation Filter< 1 %
- Filter Apply< 1 %
- Filter Definition Merger< 1 %
- Interactive HiLite Collector< 1 %
- Column Filter (PMML)< 1 %
- Number to String (PMML)< 1 %
- Target Shuffling< 1 %
- Decision Tree to Ruleset< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
- Extract Table Dimension< 1 %
- Crosstab< 1 %
- Spark to Table< 1 %
- SDF Inserter< 1 %
- SDF Stripper< 1 %
- Mol2 Reader< 1 %
- Smiles Directory Reader< 1 %
- Amazon Comprehend (Dominant Language)< 1 %
- Parameterized DB Query Reader< 1 %
- Random Number Assigner< 1 %
- Random Label Assigner< 1 %
- PMML Predictor< 1 %
- Java IF (Table)< 1 %
- IDF< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Markup Tag Filter< 1 %
- String Matcher< 1 %
- Tika Parser< 1 %
- t-SNE (L. Jonsson)< 1 %
- Value Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Image Properties< 1 %
- GET Request< 1 %
- POST Request< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Modify Time Zone< 1 %
- Moving Aggregator< 1 %
- Preset Date/Time (legacy)< 1 %
XML Reader< 1 %- SMARTS Query< 1 %
- Sum Formula< 1 %
- RDKit Add Hs< 1 %
- RDKit Molecule Extractor< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Frequency Domain Features (FDF)< 1 %
- Table Row To Variable Run-to-time Loop Start< 1 %
- Breakpoint< 1 %
- Catch Errors (Var Ports)< 1 %
- CSV Writer< 1 %
- Scorer< 1 %
- Linear Correlation< 1 %
- Create Table Structure< 1 %
- Equal Size Sampling< 1 %
- Row Splitter (Labs)< 1 %
- Ruleset Editor< 1 %
- Data Explorer< 1 %
- Linear Discriminant Analysis< 1 %
CASE Switch Data (End)< 1 %- Send Email< 1 %
- Random Matcher< 1 %
- TimeDelay Loop Start< 1 %
- Similarity Search< 1 %
- Document Vector< 1 %
- Nominal Row Filter Configuration< 1 %
- JSON Column Combiner< 1 %
- Salesforce Simple Query< 1 %
- XGBoost Predictor (Regression)< 1 %
- String to XML< 1 %
- Row Splitter (col+)< 1 %
- Text Classifier Predictor< 1 %
Views
- This node has no views
Workflows
00_Combine_Clean_and_Summarize_Spreadsheet_DataKNIME Hub- 00_Your_First_Workflow_SolutionKNIME Hub
- 0009582-6KNIME Hub
- 01_Fault_Tolerant_Workflow_OrchestrationKNIME Hub
- 01_Fault_Tolerant_Workflow_OrchestrationKNIME Hub
- Show all 389 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.