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
- Joiner10 %
- Column Filter6 %
- String Manipulation5 %
- GroupBy5 %
- String to Date&Time3 %
Row Filter (deprecated)3 %- Excel Writer3 %
- Duplicate Row Filter3 %
- Column Combiner3 %
Column Rename3 %- Column Resorter3 %
- Rule Engine2 %
- Concatenate2 %
- Reference Row Filter1 %
- Rule-based Row Filter1 %
- String Replacer1 %
Number To String1 %- Column Expressions1 %
- Cell Splitter1 %
- Pivot1 %
Row Splitter (deprecated)< 1 %- Value Lookup< 1 %
- CSV Writer< 1 %
- Math Formula< 1 %
- String to Number< 1 %
- Column Aggregator< 1 %
- Constant Value Column< 1 %
Cell Replacer< 1 %- Sorter< 1 %
Strings To Document< 1 %- Column Merger< 1 %
- Table Manipulator< 1 %
- Column Appender< 1 %
Concatenate (Optional in)< 1 %- Column Renamer< 1 %
- RowID< 1 %
- Cross Joiner< 1 %
Hash Calculator< 1 %- String Manipulation (Multi Column)< 1 %
- Value Counter< 1 %
Joiner< 1 %- Table Row to Variable Loop Start< 1 %
- Missing Value< 1 %
- Table Row to Variable< 1 %
- Loop End< 1 %
- Column Splitter< 1 %
- Number to String< 1 %
- Rule-based Row Splitter< 1 %
- String to Date/Time (legacy)< 1 %
- String to Path< 1 %
- Group Loop Start< 1 %
Variable to Table Column< 1 %- Table Transposer< 1 %
- Date&Time Part Extractor< 1 %
- Column Comparator< 1 %
- DB Writer< 1 %
- Chunk Loop Start< 1 %
- Column Renamer (Dictionary)< 1 %
- Line Chart (JFreeChart)< 1 %
- Nominal Value Row Filter< 1 %
Regex Extractor< 1 %- Column List Loop Start< 1 %
- End IF< 1 %
- Date&Time Difference< 1 %
- Decision Tree Learner< 1 %
- Node Name Filter< 1 %
- Partitioning< 1 %
- Rank< 1 %
- Punctuation Erasure< 1 %
- Nominal Row Filter Configuration< 1 %
Database Writer< 1 %Counting Loop Start< 1 %Recursive Loop End< 1 %- Binner (Dictionary)< 1 %
- Reference Column Resorter< 1 %
- Unpivot< 1 %
- Bar Chart< 1 %
- Molecule Type Cast< 1 %
- Send to Power BI< 1 %
- Table to R< 1 %
- Outlier Removal< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Reference Row Splitter< 1 %
- Ungroup< 1 %
- Crosstab< 1 %
- Excel Cell Updater< 1 %
- Scatter Plot (JavaScript)< 1 %
- Object Inserter< 1 %
Table Row to Variable< 1 %- ARFF Writer< 1 %
- Column Name Extractor< 1 %
- Lag Column< 1 %
- Column Rename (Regex)< 1 %
- Subset Matcher< 1 %
- Java Snippet Row Filter< 1 %
Python View< 1 %- GET Request< 1 %
- XPath< 1 %
- Find MIME-Type< 1 %
Database Update< 1 %- Hierarchical Clustering< 1 %
- Category to Number< 1 %
- Row Aggregator< 1 %
- String Replacer (Dictionary)< 1 %
- Conditional Box Plot (legacy)< 1 %
- DB Update< 1 %
- Counter Generation< 1 %
- One Rule Inserter< 1 %
- Random Matcher< 1 %
- Value Selection (legacy)< 1 %
- String to JSON< 1 %
- POST Request< 1 %
- String to XML< 1 %
- HTTP Retriever< 1 %
- Empty Collection to Missing< 1 %
- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- One to Many< 1 %
- Number to String (PMML)< 1 %
- Color Manager< 1 %
- Table View< 1 %
Excel Sheet Appender (XLS)< 1 %- String Matcher< 1 %
- Tika Language Detector< 1 %
- Strings to Document< 1 %
- Interactive Value Filter Widget< 1 %
- R Snippet< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 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 %
- Plate Heatmap Viewer< 1 %
- Evaluate Excel Formula< 1 %
- Table Creator< 1 %
- Recursive Loop Start< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Column Auto Type Cast< 1 %
Column Appender< 1 %- Column to Grid< 1 %
Linear Correlation< 1 %- Domain Calculator< 1 %
- Double to Integer< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Missing Value (Apply)< 1 %
- Number Rounder< 1 %
- Row to Column Names< 1 %
String Replace (Dictionary)< 1 %- Top k Row Filter< 1 %
- Kaplan-Meier Estimator< 1 %
- Independent groups t-test< 1 %
- Extract Table Spec< 1 %
- Parquet Writer< 1 %
- SDF Writer< 1 %
DB Table Creator< 1 %- Item Set Finder (Borgelt)< 1 %
Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Tableau Writer< 1 %
- Doc2Vec Learner (legacy)< 1 %
- RegEx Filter< 1 %
- Google Sheets Appender< 1 %
- Google Sheets Updater< 1 %
- Column Filter (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Date&Time Shift< 1 %
- RDKit From Molecule< 1 %
- Normalize Plates (NPI)< 1 %
- Open in Python< 1 %
- R Plot< 1 %
- ZXing Encoder< 1 %
- Regex Substring< 1 %
- 2D/3D Scatterplot< 1 %
- XLS Coloured Writer< 1 %
- Create Collection Column< 1 %
- Split Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
- Breakpoint< 1 %
- Variable to Table Column< 1 %
- Table Column 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 %
- Loop End (Column Append)< 1 %
Interval Loop Start< 1 %- Variable Condition Loop End< 1 %
- Recursive Loop End< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- k-Means< 1 %
- Decision Tree Predictor< 1 %
- Linear Regression Learner< 1 %
- Scorer< 1 %
- Association Rule Learner< 1 %
- Random Forest Learner< 1 %
- Add Empty Rows< 1 %
- String to SVG< 1 %
- Edit Nominal Domain< 1 %
- Reference Column Filter< 1 %
- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Normalizer< 1 %
- String Splitter (Regex)< 1 %
- Numeric Row Splitter< 1 %
- Row Sampling< 1 %
- Set Operator< 1 %
- String Manipulation (Variable)< 1 %
- Table Updater< 1 %
- Table Difference Finder< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- Statistics< 1 %
- CASE Switch End< 1 %
- Empty Table Switch< 1 %
- Interactive Table (legacy)< 1 %
- Box Plot< 1 %
- Line Plot< 1 %
- Pie Chart< 1 %
- Scatter Plot< 1 %
- Statistics View< 1 %
- DB Insert< 1 %
- Parameterized DB Query Reader< 1 %
- DB Table Creator< 1 %
- Similarity Search< 1 %
- Bar Chart (JavaScript)< 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 %
- OSM Map View< 1 %
- Excel Reader< 1 %
- Markup Tag Filter< 1 %
- Create File/Folder Variables< 1 %
- Delete Files/Folders (Table)< 1 %
- Path to String< 1 %
- Transfer Files (Table)< 1 %
- Google Sheets Writer< 1 %
- Heatmap (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- Value Selection Widget< 1 %
- JSON Row Combiner< 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 %
- Webpage Retriever< 1 %
- String to Duration< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Date< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- Preset Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- XML Column Combiner< 1 %
- Column to XML< 1 %
- Anonymization< 1 %
- Google Address Geocoder< 1 %
- Regex Extractor< 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 %
- Conditional Box Plot (JavaScript)< 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 (legacy)< 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 %
- Chart View< 1 %
- TIBCO Spotfire File Writer< 1 %
- Fingerprint From Set Bits list< 1 %
- PDB Saver< 1 %
- Trim Table< 1 %
- Combine Columns by Header< 1 %
- SSMD (PC x NC)< 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 %
- IF Switch< 1 %
Hive Loader (legacy)< 1 %- DB Query Reader< 1 %
- Conditional Label Assigner< 1 %
- k-Medoids< 1 %
- Bubble Chart (Plotly)< 1 %
- Histogram (JavaScript)< 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)< 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 (legacy)< 1 %
- Zip Files (legacy)< 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 %- Variable Loop End< 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 %
- Box Plot (JavaScript)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- Sunburst Chart (JavaScript)< 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)< 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 %
- RDKit To Molecule< 1 %
- BERT Classification Learner< 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 %
- HTML Parser< 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 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- Show all 613 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.