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 Successors
- Column Merger10 %
- Column Filter9 %
- Joiner6 %
- Excel Writer4 %
- Concatenate3 %
- GroupBy3 %
- Row Filter3 %
Column Rename3 %- Rule Engine3 %
- String to Number3 %
- Missing Value3 %
- Column Resorter2 %
- Duplicate Row Filter2 %
- String Manipulation2 %
- Column Combiner2 %
- Rule-based Row Filter2 %
- Column Expressions1 %
- Math Formula1 %
- Number to String1 %
- Column Renamer1 %
- Sorter1 %
- Reference Row Filter< 1 %
- Column Appender< 1 %
- String to Date&Time< 1 %
- Column Aggregator< 1 %
- CSV Writer< 1 %
- Constant Value Column< 1 %
- Row Splitter< 1 %
- Table Manipulator< 1 %
- Column Auto Type Cast< 1 %
- Loop End< 1 %
- Cell Splitter< 1 %
Cell Replacer< 1 %- String Replacer< 1 %
- String Manipulation (Multi Column)< 1 %
- Pivot< 1 %
- Column Splitter< 1 %
- Rule-based Row Splitter< 1 %
XLS Writer< 1 %- Value Lookup< 1 %
- Case Converter< 1 %
- Date&Time Difference< 1 %
- Table Transposer< 1 %
Column Filter< 1 %Python Script (1⇒1)< 1 %- Value Counter< 1 %
- Column Renamer (Dictionary)< 1 %
- Group Loop Start< 1 %
- Partitioning< 1 %
- RowID< 1 %
- Date&Time to String< 1 %
- Column Comparator< 1 %
- DB Writer< 1 %
- Math Formula (Multi Column)< 1 %
CSV Writer< 1 %Scorer< 1 %- Create Bit Vector< 1 %
- Table Row to Variable Loop Start< 1 %
- Extract Date&Time Fields< 1 %
- Loop End (Column Append)< 1 %
- Unpivot< 1 %
- Recursive Loop End< 1 %
- Run Maestro< 1 %
- TimeDelay Loop End< 1 %
- Tableau Writer< 1 %
- Bar Chart< 1 %
Database Update< 1 %- Color Manager< 1 %
- Date&Time-based Row Filter< 1 %
- DB Update< 1 %
- DL Python Network Executor< 1 %
- Table Writer< 1 %
Joiner< 1 %- Table View (JavaScript)< 1 %
- Table View< 1 %
- Statistics< 1 %
- Interactive Table (legacy)< 1 %
- Molecule Type Cast< 1 %
- Strings to Document< 1 %
- R Snippet< 1 %
- Row Aggregator< 1 %
Recursive Loop End (2 ports)< 1 %- Nominal Value Row Filter< 1 %
- Round Double< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Send to Tableau Server< 1 %
- t-SNE (L. Jonsson)< 1 %
- String to Number (PMML)< 1 %
Variable to Table Column< 1 %- Linear Regression Learner< 1 %
- Cell Splitter By Position< 1 %
- Column Rename (Regex)< 1 %
- Reference Column Filter< 1 %
String Replace (Dictionary)< 1 %Strings To Document< 1 %- Date&Time Shift< 1 %
- Conditional Box Plot (legacy)< 1 %
- Variable Loop End< 1 %
- Reference Column Splitter< 1 %
- Normalizer (Apply)< 1 %
- Substructure Matcher< 1 %
- Plate Heatmap Viewer< 1 %
- ARIMA Visualization< 1 %
- Add Empty Rows< 1 %
Number To String< 1 %- End IF< 1 %
Excel Writer (XLS)< 1 %- Case Converter< 1 %
- String to JSON< 1 %
- R Learner< 1 %
Variable Loop End< 1 %Excel Writer (XLS)< 1 %- Regex Extractor< 1 %
- Configurable Empty Table Switch< 1 %
- Split Collection Column< 1 %
Table Writer< 1 %- Double to Integer< 1 %
- SDF Writer< 1 %
Excel Sheet Appender (XLS)< 1 %- Column Filter (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- POST Request< 1 %
- Time Difference (legacy)< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Table Column to Variable< 1 %
- Numeric Row Splitter< 1 %
- Nominal Row Filter Configuration< 1 %
DB Table Creator< 1 %- Table Row to Variable< 1 %
- Path to String< 1 %
Table Row To Variable Loop Start< 1 %Loop End (2 ports)< 1 %- Lag Column< 1 %
- Column to Grid< 1 %
- Table Validator< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Regex Split< 1 %
- Punctuation Erasure< 1 %
- Moving Aggregator< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit Fingerprint< 1 %
Date Extractor< 1 %- Catch Errors (Data Ports)< 1 %
- Column Name Extractor< 1 %
- Row Filter (Labs)< 1 %
- Rank< 1 %
- Renderer to Image< 1 %
- Data Explorer< 1 %
- Line Plot (Plotly)< 1 %
- Data to Report (BIRT)< 1 %
- Modify Date< 1 %
- Breakpoint< 1 %
- Python Script (legacy)< 1 %
- Variable to Table Column< 1 %
- MolExporter< 1 %
- Create Collection Column< 1 %
Recursive Loop Start< 1 %- k-Means< 1 %
Column Appender< 1 %Linear Correlation< 1 %- Table Validator (Reference)< 1 %
- Domain Calculator< 1 %
- Normalizer< 1 %
- Missing Value (Apply)< 1 %
- Set Operator< 1 %
- Pie chart (legacy)< 1 %
- Image Viewer< 1 %
Extract Date&Time Fields< 1 %- Extract Table Spec< 1 %
- DB Insert< 1 %
Excel Sheet Appender (XLS)< 1 %- Heatmap (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- RDKit To InChI< 1 %
Counting Loop Start< 1 %- Scorer< 1 %
- Row Splitter (Labs)< 1 %
- Table Difference Finder< 1 %
- Keras Network Learner< 1 %
- Image Resizer< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Row to Column Names< 1 %
- Value Selection Widget< 1 %
- Cell to Model< 1 %
- Number to String (PMML)< 1 %
- Statistics View< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Column List Loop Start< 1 %
Concatenate (Optional in)< 1 %- Auto-Binner< 1 %
- Numeric Binner< 1 %
Cell Splitter< 1 %- Many to One< 1 %
- Cross Joiner< 1 %
- Constant Value Column Filter< 1 %
- Crosstab< 1 %
- Line Plot (legacy)< 1 %
- OpenBabel< 1 %
- Java Snippet (simple)< 1 %
- String to Term< 1 %
- Document Viewer< 1 %
- JSON to Table< 1 %
- Object Inserter< 1 %
- Date&Time to legacy Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Modify Time< 1 %
- Google Address Geocoder< 1 %
- Similarity Matrix (from Molecules)< 1 %
Table Column to Variable< 1 %Recursive Loop Start (2 ports)< 1 %- Random Forest Learner< 1 %
- Linear Correlation< 1 %
- Low Variance Filter< 1 %
- Reference Column Resorter< 1 %
- Extract Table Dimension< 1 %
- DB Merge< 1 %
Send to Tableau Server (Hyper)< 1 %Tableau Writer (Hyper)< 1 %- Table to JSON< 1 %
Regex Extractor< 1 %- Container Output (Table)< 1 %
- Bar Chart (JFreeChart)< 1 %
- Send to Power BI< 1 %
- Set Molecule Title< 1 %
- X-Aggregator< 1 %
- One to Many< 1 %
- Dictionary Tagger< 1 %
- GET Request< 1 %
- Molecule Writer (from MAE)< 1 %
- X-Partitioner< 1 %
- Bar Chart (JavaScript)< 1 %
Table to PDF< 1 %- Empty Table Switch< 1 %
- Merge Variables< 1 %
- JSON Path< 1 %
- Threshold Analyzer< 1 %
- Fingerprints Expander< 1 %
Database Reader< 1 %- DBSCAN< 1 %
- Ungroup< 1 %
- String Distances< 1 %
- Line Chart (JFreeChart)< 1 %
TIBCO File Writer< 1 %- String Matcher< 1 %
- Columns to JSON< 1 %
- Global Thresholder< 1 %
- Date Field Extractor (legacy)< 1 %
- Column to XML< 1 %
- RDKit Generate Coords< 1 %
- MapQuest Geocoder< 1 %
- HTTP Retriever< 1 %
- Lookup and Add Columns< 1 %
- Zip Files (legacy)< 1 %
- Decision Tree Learner< 1 %
- Decision Tree Predictor< 1 %
Numeric Scorer< 1 %Color Appender< 1 %- Tika Language Detector< 1 %
- Stop Word Filter< 1 %
- Value Filter (legacy)< 1 %
- Molecule to CDK< 1 %
- Lipinski's Rule-of-Five< 1 %
- RDKit Canon SMILES< 1 %
RDKit Functional Group Filter< 1 %- RDKit Find Murcko Scaffolds< 1 %
- Table Reader< 1 %
- MySQL Connector< 1 %
- Unique Term Extractor< 1 %
- String to Path< 1 %
- Moving Average< 1 %
- TIBCO Spotfire File Writer< 1 %
- Number Formatter< 1 %
- Outlier Removal< 1 %
- R Snippet< 1 %
- MolConverter< 1 %
- String to URI< 1 %
- Chunk Loop Start< 1 %
Generic Loop Start< 1 %PCA< 1 %Random Forest Learner< 1 %- Category to Number< 1 %
- Edit Numeric Domain< 1 %
- Filter Apply< 1 %
String To Number (PMML)< 1 %- Rule-based Row Filter (Dictionary)< 1 %
- HiLite Table (legacy)< 1 %
- Shape Manager< 1 %
XLS Sheet Appender< 1 %Bag of Words Creator< 1 %- Google Sheets Updater< 1 %
- JSON Column Combiner< 1 %
- Tess4J< 1 %
- Add Table to R< 1 %
- Modify Time Zone< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- XML Row Combiner< 1 %
- RDKit Descriptor Calculation< 1 %
RDKit Structure Normalizer< 1 %- Text Classifier Learner< 1 %
Map Viewer< 1 %- Form Encoded HTTP Entity Creator< 1 %
- Standardizer< 1 %
- Library Filter< 1 %
- Advanced MolConverter< 1 %
- Try (Data Ports)< 1 %
Image Writer (Table Column)< 1 %Loop End (Column Append)< 1 %Missing Value< 1 %- Rule Engine (Dictionary)< 1 %
- Numeric Outliers< 1 %
- Data Generator< 1 %
- Molfile Writer< 1 %
- Amazon Comprehend (Dominant Language)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
Table to HTML< 1 %- MoSS MCSS Molecule Similarity< 1 %
- Table to H2O< 1 %
- Pie Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Index Query< 1 %
- OSM Map View< 1 %
- Geo-Coordinate Row Filter< 1 %
- Document Vector< 1 %
- Table Editor (JavaScript)< 1 %
- RDKit Molecule Substructure Filter< 1 %
Expand Well Position< 1 %- Expand Well Position< 1 %
- Extract Variables (Data)< 1 %
- Extract Context Properties< 1 %
- Variable Creator< 1 %
Variable Condition Loop End< 1 %- Number to Category (Apply)< 1 %
Parquet Writer< 1 %- Tag Filter< 1 %
- Extract Duration Fields< 1 %
- XML Column Combiner< 1 %
- Molecular Properties< 1 %
- RDKit Salt Stripper< 1 %
- Duplicate Filter< 1 %
- Combine Columns by Header< 1 %
Python Plot< 1 %Table Row to Variable< 1 %Variable to Table Row< 1 %Database Writer< 1 %Database Connector< 1 %Recursive Loop End< 1 %Logistic Regression Learner< 1 %- Bootstrap Sampling< 1 %
String To Number< 1 %- Extract Missing Value Cause< 1 %
Number To String (PMML)< 1 %CASE Switch Data (End)< 1 %- Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Counter Generation< 1 %
- Matrix Distance< 1 %
- Similarity Search< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
H2O MOJO Predictor (Classification)< 1 %- Item Set Finder (Borgelt)< 1 %
- JSON Row Combiner< 1 %
- Table to R< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Generator (legacy)< 1 %
- XPath< 1 %
- Fingerprints< 1 %
- RDKit Interactive Table< 1 %
- RDKit From Molecule< 1 %
- HTML Parser< 1 %
- LDB Writer< 1 %
- Canvas Fingerprint Generation< 1 %
- Table Viewer< 1 %
- Uniquify IDs< 1 %
- Create Well Position< 1 %
- Spell Checker: Create Rules< 1 %
- Naming< 1 %
- PLANTS runner< 1 %
- Create Directory (legacy)< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Database SQL Executor< 1 %- Feature Selection Filter< 1 %
Naive Bayes Learner< 1 %- Naive Bayes Predictor< 1 %
- Cluster Assigner< 1 %
- MultiLayerPerceptron Predictor< 1 %
- RProp MLP Learner< 1 %
- Regression Predictor< 1 %
- Numeric Scorer< 1 %
- SMOTE< 1 %
- Association Rule Learner< 1 %
- SVM Learner< 1 %
- Binner (Dictionary)< 1 %
- Correlation Filter< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Equal Size Sampling< 1 %
- Nominal Value Row Splitter< 1 %
- Subset Matcher< 1 %
Missing Value< 1 %- Row Sampling< 1 %
- Ruleset Editor< 1 %
- Kaplan-Meier Estimator< 1 %
- IF Switch< 1 %
- Create Temp Dir (legacy)< 1 %
- Send Email< 1 %
- Interactive Histogram (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Save Workflow< 1 %
- Random Number Assigner< 1 %
- One Row to Many< 1 %
- Random Label Assigner< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- Cell to PMML< 1 %
- MoSS< 1 %
- Generic Web Service Client< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Histogram Chart (JFreeChart)< 1 %
Send to Power BI< 1 %- Java Snippet Row Filter< 1 %
- Word2Vec Learner (legacy)< 1 %
- IDF< 1 %
- Diacritic Remover< 1 %
- N Chars Filter< 1 %
- Replacer< 1 %
- Dictionary Tagger (Multi Column)< 1 %
POS tagger< 1 %- POS Tagger< 1 %
- Term to String< 1 %
- Tag Cloud< 1 %
- Column Selection (legacy)< 1 %
- Lift Chart (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Container Output (JSON)< 1 %
- JSON Diff< 1 %
- Image Normalizer< 1 %
- Projector< 1 %
Python Script (2⇒2)< 1 %- Create Date&Time Range< 1 %
- Table to HTML String< 1 %
- Remove Empty Rows< 1 %
- Fingerprint Similarity< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Two Component Reaction< 1 %
Location Extractor< 1 %- Geo Distances< 1 %
- URL Extractor< 1 %
Write FASTA< 1 %- Canonical SMILES< 1 %
- Correlation Concatenation< 1 %
- Append to Collection< 1 %
- Missing to Empty Collection< 1 %
- Save File Locally< 1 %
- ZXing Encoder< 1 %
- Binary Objects to Strings< 1 %
- Table Creator< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Counting Loop Start< 1 %
- Hierarchical Clustering< 1 %
- String Manipulation (Variable)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- One-way ANOVA< 1 %
- Independent groups t-test< 1 %
- ROC Curve (legacy)< 1 %
- ORC Writer< 1 %
- Amazon Comprehend (Sentiment)< 1 %
- Parallel Chunk Start< 1 %
- Microsoft SQL Server Connector< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Java Snippet Row Splitter< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Markup Tag Filter< 1 %
- Create Temp Folder< 1 %
- Transfer Files (Table)< 1 %
- Shapefile writer< 1 %
- Date&Time Input (legacy)< 1 %
- Tag Cloud (JavaScript)< 1 %
XML Writer< 1 %- RDKit From IUPAC< 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 286 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.