This node aggregates multiple columns in a separate new column, whose type is a "collection type". The cells in the new column are typed collections of cells; that is, the content can be safely be split into the original column content. The reverse operation is available in the "Split Collection Column" node.
Options
Manual Selection
Wildcard/Regex Selection
Type Selection
Collection type
Output table structure
Popular Successors
- Association Rule Learner7 %
- Ungroup4 %
- Split Collection Column3 %
- Table Row to Variable3 %
- Column Filter3 %
Excel Writer (XLS)3 %- Joiner2 %
CSV Writer2 %- Collection to String2 %
- Partitioning2 %
- GroupBy2 %
- Shuffle1 %
- Create Collection Column1 %
Row Filter (deprecated)1 %- Association Rule Learner (Borgelt)1 %
Loop End< 1 %- String Manipulation< 1 %
- Table Row to Variable Loop Start< 1 %
Column Rename< 1 %- Excel Writer< 1 %
- k-Means< 1 %
String To Number< 1 %Joiner< 1 %- Append to Collection< 1 %
- Item Set Finder (Borgelt)< 1 %
- Subset Matcher< 1 %
- Sorter< 1 %
- Column Expressions< 1 %
Variable to Table Column< 1 %- Column Resorter< 1 %
- Rule Engine< 1 %
- HeatMap (JFreeChart)< 1 %
- Data Row to Image< 1 %
- Column Appender< 1 %
DL Network Executor< 1 %- Image Resizer< 1 %
- Decision Tree Learner< 1 %
Concatenate (Optional in)< 1 %- String to Number< 1 %
- Rule-based Row Filter< 1 %
- Auto-Binner< 1 %
Number To String< 1 %- CASE Switch End< 1 %
- Value Selection Configuration< 1 %
- Table View (JavaScript)< 1 %
- Multiobjective Score Computation< 1 %
Database Writer< 1 %- Many to One< 1 %
- Duplicate Row Filter< 1 %
- Color Manager< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop Start< 1 %- Column Merger< 1 %
- Cross Joiner< 1 %
- Key-Collection HiLite Translator< 1 %
- Table Manipulator< 1 %
- Math Formula (Multi Column)< 1 %
- Concatenate< 1 %
- Create Bit Vector< 1 %
- Column Comparator< 1 %
- Row Sampling< 1 %
- Rule Engine (Dictionary)< 1 %
- Interactive Table (legacy)< 1 %
- Random Item Inserter< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- Math Formula< 1 %
- String to JSON< 1 %
Python Script (2⇒1)< 1 %- R Snippet< 1 %
- RDKit Molecule Highlighting< 1 %
- Insert into List< 1 %
- List To Set< 1 %
- Table Column to Variable< 1 %
- Create Byte Vector< 1 %
- Column Combiner< 1 %
- Column Renamer< 1 %
- Lag Column< 1 %
- Reference Row Filter< 1 %
- String Splitter (Regex)< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- OSM Map View< 1 %
Regex Extractor< 1 %- Fingerprint From Counts list< 1 %
- Empty Collection to Missing< 1 %
- Set To List< 1 %
- Collection Size< 1 %
Variable to Table Column< 1 %- Variable to Table Column< 1 %
Table Row to Variable< 1 %- CSV Writer< 1 %
- Java Snippet< 1 %
- Loop End< 1 %
- Chunk Loop Start< 1 %
- Group Loop Start< 1 %
Recursive Loop End (2 ports)< 1 %- Recursive Loop Start< 1 %
- X-Aggregator< 1 %
Cell Replacer< 1 %- Cell Splitter< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Column to Grid< 1 %
- One to Many< 1 %
- Constant Value Column< 1 %
- Linear Correlation< 1 %
- Domain Calculator< 1 %
Row Splitter (deprecated)< 1 %- Row Splitter (Labs)< 1 %
- Reference Row Splitter< 1 %
- Normalizer< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Rank< 1 %
- RowID< 1 %
- Set Operator< 1 %
- Column Splitter< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
- Ruleset Editor< 1 %
- End IF< 1 %
- Histogram (legacy)< 1 %
- Table View< 1 %
- DB Insert< 1 %
- DB Writer< 1 %
- Java Distance< 1 %
- Keras Network Executor< 1 %
- Keras Network Learner< 1 %
- Cell to Model< 1 %
- Table Indexer< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Filter< 1 %
- NGram Creator< 1 %
- String to Path< 1 %
- Value Selection Widget< 1 %
- Table to JSON< 1 %
- Columns to JSON< 1 %
- Hierarchy Extractor< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- POST Request< 1 %
- String to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
Table Column to Variable< 1 %- ARFF Writer< 1 %
- Feature Selection Filter< 1 %
Variable Loop End< 1 %- Expand Bit Vector< 1 %
- Edit Nominal Domain< 1 %
- Reference Column Splitter< 1 %
- Many to One (PMML)< 1 %
String Replace (Dictionary)< 1 %- Statistics< 1 %
- Fingerprint Bayesian Learner< 1 %
- Counter Generation< 1 %
- Rule Viewer (local) (Legacy)< 1 %
- Corpus Creator< 1 %
- Column Packer< 1 %
- Extract URI Info< 1 %
- Catch Errors (Data Ports)< 1 %
Database Update< 1 %Loop End (2 ports)< 1 %- Counting Loop Start< 1 %
- Column List Loop Start< 1 %
- X-Partitioner< 1 %
- Numeric Binner< 1 %
- Filter Apply Row Splitter< 1 %
- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
- HiLite Table (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Distance Matrix Calculate< 1 %
- Similarity Search< 1 %
XLS Writer< 1 %Excel Sheet Appender (XLS)< 1 %- String Matcher< 1 %
- Tags to String< 1 %
- Heatmap (JavaScript)< 1 %
- JSON Column Combiner< 1 %
- Container Output (JSON)< 1 %
- Image Viewer< 1 %
Python Script (1⇒1)< 1 %- Table Difference Checker< 1 %
- Fingerprint From Set Bits list< 1 %
- Set Atom Selection< 1 %
- Byte Vector Distances< 1 %
Table Column to Variable< 1 %- Read Images< 1 %
Counting Loop Start< 1 %Variable Condition Loop End< 1 %Recursive Loop End< 1 %Recursive Loop Start (2 ports)< 1 %- Naive Bayes Learner< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Learner< 1 %
- Random Forest Learner< 1 %
- Random Forest Learner (Regression)< 1 %
- Distance Matrix Pair Extractor< 1 %
- Case Converter< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Rename (Regex)< 1 %
- Table Validator< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Number Rounder< 1 %
- Numeric Row Splitter< 1 %
- Cache< 1 %
- Extract Table Dimension< 1 %
- ROC Curve (legacy)< 1 %
- Table to Spark< 1 %
- SDF Writer< 1 %
- DL Python Network Executor< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Prediction Fusion< 1 %
Send to Power BI< 1 %- Java Snippet (simple)< 1 %
- TF< 1 %
- Strings to Document< 1 %
- Value Selection (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- JSON Path< 1 %
- JSON Transformer< 1 %
JSON Writer< 1 %- Table to R< 1 %
- Date&Time Difference< 1 %
- Window Loop Start< 1 %
- Column to XML< 1 %
- Molecular Properties< 1 %
- RDKit Fingerprint< 1 %
- N-Gram Extractor< 1 %
- Database Merger< 1 %
- Length< 1 %
- Missing to Empty Collection< 1 %
Fingerprint Properties< 1 %- Inject Column Properties< 1 %
- Normalize Plates (NPI)< 1 %
- Outlier Removal< 1 %
- Spell Checker: Apply Rules< 1 %
- Advanced MolConverter< 1 %
- MolConverter< 1 %
- ARIMA Learner< 1 %
- Binary Objects to Files< 1 %
- Binary Objects to Strings< 1 %
- String to URI< 1 %
- Wait...< 1 %
- Create File Name (legacy)< 1 %
- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %- Table to Image< 1 %
Database Reader< 1 %Parameterized Database Query< 1 %Database Table Creator< 1 %Table Writer< 1 %- Java Edit Variable< 1 %
Interval Loop Start< 1 %- Variable Loop End< 1 %
- Fuzzy Rule Learner< 1 %
- Fuzzy Rule Predictor< 1 %
- PNN Predictor< 1 %
- Hierarchical Clustering< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- DBSCAN< 1 %
K Nearest Neighbor< 1 %- K Nearest Neighbor< 1 %
- MDS< 1 %
- Linear Regression Learner< 1 %
- Scorer< 1 %
- SVM Learner< 1 %
- Tree Ensemble Learner< 1 %
Random Forest Learner< 1 %- Random Forest Predictor< 1 %
- Add Empty Rows< 1 %
Auto-Binner< 1 %- Binner (Dictionary)< 1 %
- Expand Byte Vector< 1 %
Cell Splitter< 1 %- Category to Number< 1 %
Column Appender< 1 %- Table Validator (Reference)< 1 %
- Edit Numeric Domain< 1 %
- Extract Missing Value Cause< 1 %
Column Filter< 1 %- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Interactive HiLite Collector< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Row Filter (Labs)< 1 %
- Denormalizer< 1 %
Normalizer< 1 %- Normalizer (PMML)< 1 %
- Nominal Probability Distribution Creator< 1 %
- Reference Column Resorter< 1 %
- String Manipulation (Multi Column)< 1 %
- String Manipulation (Variable)< 1 %
- Renderer to Image< 1 %
- Ruleset Predictor< 1 %
- Rule Engine Variable (Dictionary)< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- Numeric Outliers< 1 %
CASE Switch Data (End)< 1 %- Extract Table Spec< 1 %
- Send Email< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
Parquet Writer< 1 %- Molecule Type Cast< 1 %
- Parallel Chunk End< 1 %
- Parallel Chunk Start< 1 %
- DB Connection Closer< 1 %
DB Loader< 1 %- One Row to Many< 1 %
- One Rule Inserter< 1 %
- Random Label Assigner< 1 %
- Random Label Assigner (Data)< 1 %
- TimeDelay Loop End< 1 %
- Bit Vector Distances< 1 %
- Numeric Distances< 1 %
- String Distances< 1 %
- Matrix Distance< 1 %
- Distance Matrix Writer< 1 %
- DL Python Network Learner< 1 %
- TensorFlow Network Executor< 1 %
- Bar Chart (JavaScript)< 1 %
- Scatter Plot (Plotly)< 1 %
Table to PDF< 1 %- Generic Web Service Client< 1 %
DL4J Feedforward Learner (legacy)< 1 %- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- Table To DL4J Vector (Classification) (legacy)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- OSM Map to Image< 1 %
Excel Writer (XLS)< 1 %- Java Snippet Row Splitter< 1 %
Tableau Writer (Hyper)< 1 %- Word2Vec Learner (legacy)< 1 %
- Punctuation Erasure< 1 %
- RegEx Filter< 1 %
- Replacer< 1 %
- Stanford Lemmatizer< 1 %
- POS Tagger< 1 %
Stanford tagger< 1 %- Stanford Tagger< 1 %
- Bag Of Words Creator< 1 %
- String to Term< 1 %
- t-SNE (L. Jonsson)< 1 %
- Path to String< 1 %
- Google Sheets Connector< 1 %
- Column Filter (legacy)< 1 %
- String Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- JSON to Table< 1 %
- Image to DataRow< 1 %
- Inverter< 1 %
- Multi Feature Inserter< 1 %
- Object Inserter< 1 %
Python Script (1⇒1)< 1 %- R View (Table)< 1 %
- Date&Time to String< 1 %
- UNIX Timestamp to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Date&Time Shift< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- String to Date/Time (legacy)< 1 %
- XGBoost Predictor (Regression)< 1 %
- XML Column Combiner< 1 %
- String to XML< 1 %
- Row Splitter (col+)< 1 %
- Molecule to CDK< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Interactive Table< 1 %
Map Viewer< 1 %Extract Attribute< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- (3D) Fragment library design workflowKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- Show all 872 workflows
Links
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.