Combines the content of a set of columns and appends the concatenated string as separate column to the input table. The user needs to specify in the dialog the columns of interest and some other properties, such as delimiter to separate the different cell contents and quoting options.
Options
Popular Successors
- Joiner7 %
- Column Filter4 %
- String Manipulation4 %
- GroupBy3 %
Number To String3 %- Column Resorter2 %
Row Filter (deprecated)2 %String to Date&Time2 %- Column Combiner2 %
- Excel Writer2 %
Strings To Document1 %- Duplicate Row Filter1 %
Column Rename1 %- Rule-based Row Filter1 %
Concatenate (Optional in)1 %- Table Row to Variable1 %
- Rule Engine1 %
- Columns to Collection1 %
- Concatenate1 %
Hash Calculator< 1 %- Column Expressions (legacy)< 1 %
- Reference Row Filter< 1 %
Cell Replacer< 1 %- String Replacer< 1 %
Row Splitter (deprecated)< 1 %Variable to Table Column< 1 %Constant Value Column< 1 %- String to Number< 1 %
- Cell Splitter< 1 %
- Line Chart (JFreeChart)< 1 %
- Binner (Dictionary)< 1 %
Joiner< 1 %Regex Extractor< 1 %- Column List Loop Start< 1 %
- Pivot< 1 %
- End IF< 1 %
- Math Formula< 1 %
- Decision Tree Learner< 1 %
- Column Merger< 1 %
- Sorter< 1 %
- Table Transposer< 1 %
- Node Name Filter< 1 %
- Cross Joiner< 1 %
- Rule-based Row Splitter< 1 %
- Punctuation Erasure< 1 %
- Nominal Row Filter Configuration< 1 %
Database Writer< 1 %Counting Loop Start< 1 %Recursive Loop End< 1 %- Nominal Value Row Filter< 1 %
- Molecule Type Cast< 1 %
- Table to R< 1 %
- Outlier Removal< 1 %
- CSV Writer< 1 %
Loop End< 1 %- Chunk Loop Start< 1 %
- Group Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Table Manipulator< 1 %
- Crosstab< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Object Inserter< 1 %
- ARFF Writer< 1 %
- Column Appender< 1 %
- Column Name Extractor< 1 %
- Subset Matcher< 1 %
- Value Lookup< 1 %
- Java Snippet Row Filter< 1 %
Python View< 1 %- XPath< 1 %
- Find MIME-Type< 1 %
Database Update< 1 %- Hierarchical Clustering< 1 %
- Category to Number< 1 %
- Conditional Box Plot (legacy)< 1 %
DB Update< 1 %- One Rule Inserter< 1 %
- Random Matcher< 1 %
- Value Selection (legacy)< 1 %
- String to XML< 1 %
- HTTP Retriever< 1 %
- Empty Collection to Missing< 1 %
- Numeric Binner< 1 %
- Column Aggregator< 1 %
- One to Many< 1 %
- Number to String (PMML)< 1 %
Excel Sheet Appender (XLS)< 1 %- String Matcher< 1 %
- Tika Language Detector< 1 %
- Interactive Value Filter Widget< 1 %
- R Snippet< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Date&Time Part Extractor< 1 %
- Moving Average< 1 %
- RDKit Interactive Table< 1 %
Location Extractor< 1 %- Run Garbage Collector< 1 %
Expand Well Position< 1 %- Normalize Plates (POC)< 1 %
- Z-Primes (PC x NC)< 1 %
- Evaluate Excel Formula< 1 %
- Table Creator< 1 %
- Recursive Loop Start< 1 %
Auto-Binner< 1 %Column Appender< 1 %Linear Correlation< 1 %- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Number Rounder< 1 %
- Row to Column Names< 1 %
- String Manipulation (Multi Column)< 1 %
String Replace (Dictionary)< 1 %- String Replacer (Dictionary)< 1 %
- Unpivot< 1 %
- Kaplan-Meier Estimator< 1 %
- Independent groups t-test< 1 %
- Extract Table Spec< 1 %
- SDF Writer< 1 %
DB Table Creator< 1 %- Counter Generation< 1 %
- Item Set Finder (Borgelt)< 1 %
Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Java Snippet (simple)< 1 %
- Tableau Writer< 1 %
- Doc2Vec Learner (legacy)< 1 %
- RegEx Filter< 1 %
- Strings to Document< 1 %
- Google Sheets Updater< 1 %
- Column Filter (legacy)< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- POST Request< 1 %
- RDKit From Molecule< 1 %
- Normalize Plates (NPI)< 1 %
- SSMD (PC x NC)< 1 %
- Plate Heatmap Viewer< 1 %
- Open in Python< 1 %
- R Plot< 1 %
- ZXing Encoder< 1 %
- Regex Substring< 1 %
- 2D/3D Scatterplot< 1 %
- XLS Coloured Writer< 1 %
- Split Collection Column< 1 %
Copy/Move Files< 1 %- Breakpoint< 1 %
- Variable to Table Column< 1 %
- Table Column to Variable< 1 %
Table Row to Variable< 1 %Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %CSV Writer< 1 %Database Table Creator< 1 %- Table Writer< 1 %
- Java Snippet< 1 %
- Loop End< 1 %
- Loop End (Column Append)< 1 %
Interval Loop Start< 1 %- Variable Condition Loop End< 1 %
- Recursive Loop End< 1 %
- Variable Loop End< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
k-Means (deprecated)< 1 %- Decision Tree Predictor< 1 %
- Linear Regression Learner< 1 %
- Scorer< 1 %
- Association Rule Learner< 1 %
- Random Forest Learner< 1 %
- Constant Value Row Appender< 1 %
- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Column Comparator< 1 %
- Number to String< 1 %
- String to SVG< 1 %
- Column Renamer< 1 %
- Column Renamer (Dictionary)< 1 %
- Lag Column< 1 %
- Column Name Replacer< 1 %
- Column to Grid< 1 %
- Domain Calculator< 1 %
- Edit Nominal Domain< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Normalizer< 1 %
- Table Partitioner< 1 %
- Missing Value (Apply)< 1 %
- Missing Value< 1 %
- Rank< 1 %
- Reference Column Resorter< 1 %
- String Splitter (Regex)< 1 %
- Row Aggregator< 1 %
- RowID< 1 %
- Numeric Row Splitter< 1 %
- Row Sampler< 1 %
- Set Operator< 1 %
Column Splitter< 1 %- String Manipulation (Variable)< 1 %
- Table Updater< 1 %
- Table Difference Finder< 1 %
- Top k Row Filter< 1 %
- Ungroup< 1 %
- Value Counter< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- Statistics< 1 %
- CASE Switch End< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
- Bar Chart< 1 %
- Box Plot< 1 %
- Line Plot< 1 %
- Pie Chart< 1 %
- Scatter Plot< 1 %
- Statistics View< 1 %
- Table View< 1 %
- Parquet Writer< 1 %
DB Insert< 1 %- Parameterized DB Query Reader< 1 %
DB Writer< 1 %DB Table Creator< 1 %- Similarity Search< 1 %
- Line Plot (Plotly)< 1 %
- External Tool< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Math Formula (Multi Column)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Index Query< 1 %
- Table Indexer< 1 %
Microsoft Authenticator (Deprecated)< 1 %- OSM Map View< 1 %
Excel Writer (XLS)< 1 %- Excel Reader< 1 %
- Excel Cell Updater< 1 %
- Send to Power BI< 1 %
- Markup Tag Filter< 1 %
- Create File/Folder Variables< 1 %
- Delete Files/Folders (Table)< 1 %
- Path to String< 1 %
- String to Path< 1 %
- Transfer Files (Table)< 1 %
- Google Sheets Appender< 1 %
- Google Sheets Writer< 1 %
- Heatmap (JavaScript) (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- Tile View (JavaScript) (legacy)< 1 %
- Nominal Row Filter Widget< 1 %
- Value Selection Widget< 1 %
- JSON Row Combiner< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
- JSON Transformer< 1 %
- Columns to JSON< 1 %
- JSON to Table< 1 %
- Python Script (legacy)< 1 %
- R View (Table)< 1 %
- Data to Report (BIRT)< 1 %
- GET Request< 1 %
- Webpage Retriever< 1 %
Date&Time Difference< 1 %Date&Time to String< 1 %String to Duration< 1 %- Date&Time-based Row Filter< 1 %
Date&Time Shift< 1 %Modify Date< 1 %- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- Preset Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- XML Column Combiner< 1 %
- Column to XML< 1 %
- RDKit To Molecule< 1 %
- Anonymization< 1 %
- Google Address Geocoder< 1 %
- Regex Extractor< 1 %
- HTML Parser< 1 %
- Set To List< 1 %
- R Snippet (2:1)< 1 %
- Extract Variables (Data)< 1 %
Database Table Selector< 1 %- X-Partitioner< 1 %
- Fuzzy c-Means< 1 %
- Create Bit Vector< 1 %
Cell Splitter< 1 %- Denormalizer< 1 %
Number To String (PMML)< 1 %- Shuffle< 1 %
- Target Shuffling< 1 %
- One-way ANOVA< 1 %
- Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
XLS Writer< 1 %POS tagger< 1 %Python Script (1⇒2)< 1 %- PUT Request< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date/Time Shift (legacy)< 1 %
- Molecule to CDK< 1 %
HTTP Retriever< 1 %- Uniquify IDs< 1 %
- Normalize Plates (Z-Score)< 1 %
- R Snippet< 1 %
Create File Name< 1 %- Java Edit Variable< 1 %
- Feature Selection Loop End< 1 %
Recursive Loop End (2 ports)< 1 %- Numeric Scorer< 1 %
- Many to One< 1 %
- Linear Correlation< 1 %
- Extract Missing Value Cause< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Numeric Outliers< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
- Extract Table Dimension< 1 %
Color Appender< 1 %- PostgreSQL Connector< 1 %
- DB Loader< 1 %
- Autocomplete Text Widget< 1 %
- Scatter Plot (Plotly)< 1 %
- Cell to Model< 1 %
- OpenBabel< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
Excel Reader (XLS)< 1 %Send to Power BI< 1 %- Word2Vec Learner (legacy)< 1 %
- Term Document Entropy< 1 %
- Frequency Filter< 1 %
- Replacer< 1 %
- List Files/Folders< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒2)< 1 %- Python View (legacy)< 1 %
UNIX Timestamp to Date&Time< 1 %- Window Loop Start< 1 %
- Mask Date/Time (legacy)< 1 %
- Geo Distances< 1 %
- N-Gram Extractor< 1 %
- Form Encoded HTTP Entity Creator< 1 %
- TIBCO Spotfire File Writer< 1 %
- Fingerprint From Set Bits list< 1 %
- PDB Saver< 1 %
- Trim Table< 1 %
- Combine Columns by Header< 1 %
Python Plot< 1 %- MolExporter< 1 %
- Strings to Binary Objects< 1 %
- String to URI< 1 %
- URL to File Path< 1 %
Loop End (2 ports)< 1 %- Logistic Regression Learner< 1 %
- Polynomial Regression Learner< 1 %
Tree Ensemble Learner (Regression)< 1 %String To Number< 1 %- Correlation Filter< 1 %
- CAIM Binner< 1 %
Double To Int< 1 %- HiLite Row Splitter< 1 %
- Column Filter (PMML)< 1 %
String To Number (PMML)< 1 %- String to Number (PMML)< 1 %
- Ruleset Predictor< 1 %
Hive Loader (legacy)< 1 %- DB Query Reader< 1 %
- Conditional Label Assigner< 1 %
- k-Medoids< 1 %
- Bubble Chart (Plotly)< 1 %
- Ligands Viewer< 1 %
Table to PDF< 1 %- Bar Chart (JFreeChart)< 1 %
- Interval Chart (JFreeChart)< 1 %
Tableau Writer (TDE)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Diacritic Remover< 1 %
- Oscar Tagger< 1 %
- Bag Of Words Creator< 1 %
- Document Vector< 1 %
- String to Term< 1 %
- Tags to String< 1 %
- Column Filter Configuration< 1 %
- Value Filter (legacy)< 1 %
- Tag Cloud (JavaScript) (legacy)< 1 %
- Container Output (Table)< 1 %
- Don't Save End< 1 %
- Image Viewer< 1 %
- Table Difference Checker< 1 %
- Time Field Extractor (legacy)< 1 %
- Country Extractor< 1 %
- OPSIN< 1 %
- Sum Formula< 1 %
RDKit Fingerprint Writer< 1 %- RDKit Two Component Reaction< 1 %
- MapQuest Geocoder< 1 %
MapzenGeocoder< 1 %- Latitude/Longitude to Coordinate< 1 %
- Hash Calculator< 1 %
- String Similarity< 1 %
- TF-IDF Similarity< 1 %
- Molecule Properties< 1 %
- Sequence Convert< 1 %
- XLS Cell Formatter< 1 %
- XLS Control Table Generator< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Benchmark Start (2 ports)< 1 %
- Collection Size< 1 %
- Save File Locally< 1 %
- Join Layout< 1 %
- Expand Well Position< 1 %
- Number Formatter< 1 %
- Range Splitter< 1 %
- BinningAnalysis< 1 %
- Normalize Plates (B-Score)< 1 %
Python Snippet< 1 %- Advanced MolConverter< 1 %
- logD< 1 %
- MolConverter< 1 %
- Desirability Ranking< 1 %
- Automated Matched Pairs< 1 %
- ARIMA Predictor< 1 %
- ARIMA Visualization< 1 %
Binary Objects to Files< 1 %Upload< 1 %Zip Files< 1 %- Try (Data Ports)< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Table Column to Variable< 1 %Image Writer (Table Column)< 1 %- Read Images< 1 %
Database Looping< 1 %Database Connector< 1 %File Reader< 1 %Table Writer< 1 %Variable Condition Loop End< 1 %Generic Loop Start< 1 %Recursive Loop Start (2 ports)< 1 %Recursive Loop Start< 1 %- Naive Bayes Learner< 1 %
- Fuzzy Rule Learner< 1 %
- PNN Predictor< 1 %
- Hierarchical Cluster View< 1 %
K Nearest Neighbor< 1 %- K Nearest Neighbor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- RProp MLP Learner< 1 %
- OPTICS Cluster Assigner< 1 %
PCA< 1 %Regression Predictor< 1 %- Regression Predictor< 1 %
Scorer< 1 %- SMOTE< 1 %
- SOTA Learner< 1 %
- SVM Predictor< 1 %
- PCA Compute< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Predictor< 1 %
Random Forest Learner< 1 %Random Forest Predictor< 1 %- Random Forest Predictor< 1 %
- Simple Regression Tree Learner< 1 %
- Create Byte Vector< 1 %
- Line Chopper< 1 %
- Number to Category (Apply)< 1 %
- Table Validator< 1 %
- Table Validator (Reference)< 1 %
- Equal Size Sampling< 1 %
Column Filter< 1 %- Row Splitter (Labs)< 1 %
- Normalizer (Apply)< 1 %
- Numeric Binner (PMML)< 1 %
- Many to One (PMML)< 1 %
- Normalizer (PMML)< 1 %
- Rank Correlation< 1 %
CASE Switch Data (End)< 1 %- Cache< 1 %
- Send Email< 1 %
- Interactive Histogram (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Shape Manager< 1 %
- Size Manager< 1 %
- Save Workflow< 1 %
- SDF Inserter< 1 %
- Molfile Writer< 1 %
- Parallel Chunk End< 1 %
- Parallel Chunk Start< 1 %
DB Merge< 1 %- Random Number Assigner< 1 %
- One Row to Many< 1 %
- Random Label Assigner (Data)< 1 %
- String Distances< 1 %
- Matrix Distance< 1 %
- Distance Matrix Calculate< 1 %
DL Network Executor< 1 %- Keras Network Learner< 1 %
- DL Python Network Executor< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Violin Plot (Plotly)< 1 %
Table to HTML< 1 %- Table to HTML (legacy)< 1 %
- Table to PDF (legacy)< 1 %
- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- Table to H2O< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
XLS Sheet Appender< 1 %Table R-View< 1 %- Java IF (Table)< 1 %
- Java Snippet Row Splitter< 1 %
- TF< 1 %
- Brat Document Writer< 1 %
- NGram Creator< 1 %
- Case Converter< 1 %
- Dictionary Filter< 1 %
- Dictionary Replacer (File-based)< 1 %
- Dictionary Replacer< 1 %
Dictionary tagger< 1 %- Dictionary Tagger< 1 %
- Wildcard Tagger< 1 %
- OpenNLP NE Tagger< 1 %
- POS Tagger< 1 %
- Sentence Extractor< 1 %
- Document Viewer< 1 %
- GeoJSON writer< 1 %
- Slider Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Generic JavaScript View (JavaScript) (legacy)< 1 %
- JSON Column Combiner< 1 %
- Kafka Producer< 1 %
- Labeling to RGB Img< 1 %
- Image Normalizer< 1 %
- Labeling to PNG Images< 1 %
- ImageJ Macro< 1 %
- Row to Network< 1 %
- Feature List Filter< 1 %
- Assign Partition< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- DELETE Request< 1 %
Duration to Number< 1 %Modify Time< 1 %Modify Time Zone< 1 %- Time Difference (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Depiction< 1 %
- Mass Calculator< 1 %
- SMARTS Query< 1 %
- RDKit Generate Coords< 1 %
- RDKit Chemical Transformation< 1 %
- RDKit Molecule Fragmenter< 1 %
- RDKit Fingerprint< 1 %
- Neo4j Writer< 1 %
- Text Classifier Learner< 1 %
- Text Classifier Predictor< 1 %
- Web Page Content Extractor< 1 %
- Date Extractor< 1 %
Map Viewer< 1 %- Coordinate to Latitude/Longitude< 1 %
- URL Extractor< 1 %
Web Searcher< 1 %- Navigate< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 00 Data GenerationKNIME Hub
- 00 Data GenerationKNIME Hub
- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- Show all 781 workflows
Links
- Compare data over monthsby izaychik63 on 2018-12-31forum.knime.com/p/52248
- Creating all combinations of two tables with multiple columnsby izaychik63 on 2024-08-31forum.knime.com/p/267519
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.