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 Predecessors
- Rule Engine6 %
- Table Transposer5 %
- Column Filter4 %
- Excel Reader4 %
- Table Creator4 %
Excel Reader (XLS)3 %- GroupBy3 %
- CSV Reader3 %
- Joiner3 %
- Cell Splitter2 %
- String Manipulation2 %
- Column Name Extractor2 %
- Create Collection Column2 %
- Row Filter2 %
Column Appender2 %- Missing Value1 %
- Column Expressions1 %
- Rule-based Row Filter1 %
- File Reader1 %
String To Number1 %- Split Collection Column1 %
- Concatenate1 %
Number To String< 1 %- Loop End (Column Append)< 1 %
- Column Appender< 1 %
Joiner< 1 %- Variable to Table Column< 1 %
XLS Reader< 1 %Excel Reader (XLS)< 1 %- Constant Value Column< 1 %
- Round Double< 1 %
- String Manipulation (Multi Column)< 1 %
- Column Combiner< 1 %
- Column Aggregator< 1 %
Column Rename< 1 %- Column Splitter< 1 %
String Replace (Dictionary)< 1 %- Create Bit Vector< 1 %
- Image Resizer< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Extract Table Spec< 1 %
- Column Resorter< 1 %
- Row Splitter< 1 %
- List Box Configuration< 1 %
- Missing Value Column Filter< 1 %
- Column to Grid< 1 %
- Lag Column< 1 %
- RowID< 1 %
Table Row to Variable< 1 %- Variable to Table Row< 1 %
- Ungroup< 1 %
- Category to Number< 1 %
- One to Many< 1 %
- Statistics< 1 %
- Math Formula< 1 %
- Table Manipulator< 1 %
- Counting Loop Start< 1 %
Database Reader< 1 %- Pivot< 1 %
- Table Reader< 1 %
- Collection to String< 1 %
- Duplicate Row Filter< 1 %
- Normalizer (Apply)< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Counter Generation< 1 %
- DB Query Reader< 1 %
- List Files/Folders< 1 %
File Reader< 1 %- Chunk Loop Start< 1 %
- Partitioning< 1 %
- String Replacer< 1 %
- Unpivot< 1 %
- JSON to Table< 1 %
- Color Manager< 1 %
Excel Reader (XLS)< 1 %- Table View (JavaScript)< 1 %
Regex Extractor< 1 %- Multiple Selection Widget< 1 %
Loop End< 1 %- Numeric Binner< 1 %
- Cross Joiner< 1 %
- Constant Value Column Filter< 1 %
- Cell Splitter By Position< 1 %
- Loop End< 1 %
- Scorer< 1 %
- Python Script (legacy)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Column List Loop Start< 1 %
- Group Loop Start< 1 %
- Association Rule Learner< 1 %
- Reference Row Filter< 1 %
- Empty Table Switch< 1 %
- Column Selection (legacy)< 1 %
- R Snippet< 1 %
Line Reader< 1 %- DB Reader< 1 %
- JSON Path< 1 %
- Parquet Reader< 1 %
- Path to String< 1 %
- Column Filter Configuration< 1 %
- Extract Date&Time Fields< 1 %
- Extract Variables (Data)< 1 %
- Java Snippet< 1 %
- Column Auto Type Cast< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Nominal Value Row Filter< 1 %
- Regex Split< 1 %
- Sorter< 1 %
- Math Formula (Multi Column)< 1 %
Recursive Loop Start< 1 %- String Manipulation (Variable)< 1 %
Python Script (2⇒1)< 1 %- File Reader (Complex Format)< 1 %
- SMOTE< 1 %
- Date&Time Shift< 1 %
- Variable Loop End< 1 %
Variable to Table Row< 1 %Concatenate (Optional in)< 1 %- Auto-Binner< 1 %
Cell Replacer< 1 %- Reference Row Splitter< 1 %
- Normalizer< 1 %
- Rule-based Row Splitter< 1 %
- Time to String (legacy)< 1 %
Table Row to Variable< 1 %- Expand Bit Vector< 1 %
- Many to One< 1 %
- Create Table Structure< 1 %
- Extract Table Dimension< 1 %
- Empty Table Creator< 1 %
- Multiple Selection Configuration< 1 %
- Empty Collection to Missing< 1 %
- Table Row to Variable< 1 %
- Table Row to Variable Loop Start< 1 %
- Target Shuffling< 1 %
- IF Switch< 1 %
- Random Item Inserter< 1 %
- Table to JSON< 1 %
- URI to String< 1 %
- Column Renamer< 1 %
- Row to Column Names< 1 %
CSV Reader< 1 %Database Connection Table Reader< 1 %- Decision Tree Predictor< 1 %
Scorer< 1 %- Nominal Value Row Splitter< 1 %
- Row Sampling< 1 %
- Set Operator< 1 %
- Python Edit Variable (legacy)< 1 %
- GET Request< 1 %
- Benchmark End< 1 %
Table Row To Variable Loop Start< 1 %- k-Means< 1 %
- Case Converter< 1 %
- Missing Value (Apply)< 1 %
- Variable Expressions< 1 %
- R Source (Table)< 1 %
- Create Date&Time Range< 1 %
- XPath< 1 %
- Strings to Document< 1 %
- Single Selection (legacy)< 1 %
- Column Filter Widget< 1 %
- Add Empty Rows< 1 %
- Column Rename (Regex)< 1 %
- Correlation Filter< 1 %
- Domain Calculator< 1 %
Number To String (PMML)< 1 %Merge Variables< 1 %- Data Generator< 1 %
- OpenBabel< 1 %
- Java Snippet (simple)< 1 %
- Term to String< 1 %
Python Script (1⇒1)< 1 %- R to Table< 1 %
- String to Date&Time< 1 %
- Time Difference (legacy)< 1 %
Variable to Table Column< 1 %Variable to Table Column< 1 %- ARFF Reader< 1 %
List Files< 1 %Interval Loop Start< 1 %- Extract Missing Value Cause< 1 %
- Append to Collection< 1 %
- Java Edit Variable< 1 %
- PCA< 1 %
- String to Path< 1 %
- Refresh Button Widget< 1 %
- Value Selection Widget< 1 %
- JSON Column Combiner< 1 %
- Column Comparator< 1 %
String To Number (PMML)< 1 %- Date&Time to String< 1 %
- Mask Date/Time (legacy)< 1 %
- Regression Predictor< 1 %
- PCA Apply< 1 %
- Auto-Binner (Apply)< 1 %
- Row Filter (Labs)< 1 %
- Reference Column Resorter< 1 %
Rank Correlation< 1 %Read XLS Sheet Names< 1 %- Frequency Filter< 1 %
- Date&Time-based Row Filter< 1 %
- Date Field Extractor (legacy)< 1 %
- Table Column to Variable< 1 %
- Equal Size Sampling< 1 %
- Filter Apply Row Splitter< 1 %
- Row Splitter (Labs)< 1 %
- Similarity Search< 1 %
- Value Selection Configuration< 1 %
- Interactive Value Filter Widget< 1 %
- Strings to Binary Objects< 1 %
Table Reader< 1 %Recursive Loop End< 1 %- Random Forest Learner< 1 %
- Binner (Dictionary)< 1 %
Cell Splitter< 1 %- CAIM Binner< 1 %
- Subset Matcher< 1 %
- Numeric Binner (PMML)< 1 %
- Value Counter< 1 %
CASE Switch Data (End)< 1 %- End IF< 1 %
- One Rule Inserter< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Item Set Finder (Borgelt)< 1 %
Document Data Extractor< 1 %- Column Filter (legacy)< 1 %
- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Columns to JSON< 1 %
- Node Adjacency Matrix< 1 %
Python Script (1⇒1)< 1 %- Window Loop Start< 1 %
- Time Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Substructure Counter< 1 %
- Run Heavy Garbage Collector< 1 %
- Benchmark Start< 1 %
- MolConverter< 1 %
- Fingerprints Expander< 1 %
- Catch Errors (Data Ports)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %CSV Writer< 1 %Table Writer< 1 %- Feature Selection Loop Start (1:1)< 1 %
Loop End (2 ports)< 1 %Counting Loop Start< 1 %Recursive Loop Start (2 ports)< 1 %- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Numeric Scorer< 1 %
- Random Forest Learner (Regression)< 1 %
- Tree Ensemble Statistics< 1 %
- Create Byte Vector< 1 %
- Category to Number (Apply)< 1 %
- Linear Correlation< 1 %
- Reference Column Splitter< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Low Variance Filter< 1 %
- Denormalizer< 1 %
- Normalizer Apply (PMML)< 1 %
- XML to PMML< 1 %
- Rank< 1 %
- Numeric Row Splitter< 1 %
- Shuffle< 1 %
- SDF Reader< 1 %
- Distance Matrix Calculate< 1 %
Read Excel Sheet Names (XLS)< 1 %- Word Vector Apply (legacy)< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Case Converter< 1 %
- N Chars Filter< 1 %
- Bag Of Words Creator< 1 %
- Document Vector< 1 %
- Sentence Extractor< 1 %
- String to Term< 1 %
- String Configuration< 1 %
- Double Input (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
JSON Reader< 1 %- Data Row to Image< 1 %
- Image to DataRow< 1 %
- Node Table< 1 %
- Partition Table< 1 %
Python Script (1⇒2)< 1 %- Disturber Node< 1 %
- Date&Time Difference< 1 %
Extract Date&Time Fields< 1 %- Time Generator (legacy)< 1 %
XML Reader< 1 %- RDKit Canon SMILES< 1 %
- Corpus Creator< 1 %
- WAV Reader< 1 %
- Set To List< 1 %
- URL Encode< 1 %
- Try (Data Ports)< 1 %
- Normalizer (PMML)< 1 %
- Top k Row Filter< 1 %
- Renderer to Image< 1 %
CASE Switch Data (Start)< 1 %- Extract Color< 1 %
- TimeDelay Loop Start< 1 %
- Keras Network Executor< 1 %
- Category to Class< 1 %
- NGram Creator< 1 %
- RSS Feed Reader< 1 %
- Decompress Files< 1 %
- Date&Time Input (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- String to JSON< 1 %
- Python Source (legacy)< 1 %
- Date/Time Shift (legacy)< 1 %
- Remove Empty Rows< 1 %
Column Distance< 1 %
Views
- This node has no views
Workflows
(3D) Fragment library design workflowKNIME Hub- 00 Data GenerationKNIME Hub
- 00_Guided_Labeling_for_Document_Classification_(legacy)KNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- Show all 770 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.