Groups the selected columns per row and aggregates their cells using the selected aggregation method.
To change the name of the new created aggregation column double click on the name column.
A detailed description of the available aggregation methods can be found on the 'Description' tab in the node dialog.
Options
Columns
Popular Predecessors
- Column Aggregator6 %
- GroupBy5 %
- Column Filter5 %
- Pivot5 %
Cell Splitter4 %- Joiner3 %
- Missing Value3 %
Row Filter (deprecated)3 %- Column Resorter3 %
- Math Formula2 %
- Rule Engine2 %
- Cell Splitter2 %
- Concatenate2 %
- Excel Reader2 %
- String Manipulation2 %
- Table Transposer2 %
- String to Number2 %
- Rule-based Row Filter1 %
- Math Formula (Multi Column)1 %
Column Rename1 %- Column Combiner1 %
- Table Creator< 1 %
- Column Expressions< 1 %
- Constant Value Column< 1 %
- Sorter< 1 %
- Column Merger< 1 %
- Column Appender< 1 %
- CSV Reader< 1 %
- String Manipulation (Multi Column)< 1 %
- Number to String< 1 %
- Split Collection Column< 1 %
- Column Splitter< 1 %
- Column Name Extractor< 1 %
- Excel Writer< 1 %
- Duplicate Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Column Renamer< 1 %
- Lag Column< 1 %
- Missing Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %Excel Reader (XLS)< 1 %- String to Date&Time< 1 %
XLS Reader< 1 %- RowID< 1 %
- Loop End< 1 %
- Number Rounder< 1 %
- Date&Time Part Extractor< 1 %
String Replace (Dictionary)< 1 %- Row Filter (Labs)< 1 %
- Cross Joiner< 1 %
- Regex Extractor< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop End< 1 %- Value Lookup< 1 %
Loop End< 1 %- File Reader< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %- Java Snippet Row Splitter< 1 %
Cell Replacer< 1 %- Ungroup< 1 %
- XPath< 1 %
- Column Rename (Regex)< 1 %
- Topic Extractor (Parallel LDA)< 1 %
Table Row To Variable Loop Start< 1 %- Column Comparator< 1 %
- Reference Row Filter< 1 %
- DB Reader< 1 %
- Collection to String< 1 %
- Expand Bit Vector< 1 %
- Subset Matcher< 1 %
- JSON Path< 1 %
- Row Aggregator< 1 %
- ARFF Reader< 1 %
- RDKit Substructure Counter< 1 %
- Cache< 1 %
Regex Extractor< 1 %- Column Auto Type Cast< 1 %
Joiner< 1 %- Missing Value (Apply)< 1 %
- String Replacer< 1 %
- Value Counter< 1 %
- Column Selection (legacy)< 1 %
- Domain Calculator< 1 %
- String Configuration< 1 %
- Variable to Table Column< 1 %
- Unpivot< 1 %
- Parallel Chunk End< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Difference< 1 %
- Modify Time< 1 %
- Python Script (legacy)< 1 %
Table Column to Variable< 1 %- Group Loop Start< 1 %
Recursive Loop End (2 ports)< 1 %- k-Means< 1 %
Scorer< 1 %Column Appender< 1 %- Reference Column Filter< 1 %
- Reference Column Splitter< 1 %
- Nominal Value Row Filter< 1 %
- String Splitter (Regex)< 1 %
- JSON to Table< 1 %
- R Source (Table)< 1 %
- PCA< 1 %
- Table Manipulator< 1 %
- Java Edit Variable< 1 %
- Regression Predictor< 1 %
- End IF< 1 %
- Data Generator< 1 %
- Create Bit Vector< 1 %
- Numeric Outliers< 1 %
- Rotation 2D< 1 %
- Container Input (Variable)< 1 %
Table Reader< 1 %- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Cell Splitter By Position< 1 %
- Normalizer (Apply)< 1 %
- Partitioning< 1 %
- Row Sampling< 1 %
- ROC Curve (legacy)< 1 %
- Random Number Assigner< 1 %
- Java Snippet Row Filter< 1 %
- Document Data Extractor< 1 %
- Date&Time to String< 1 %
- Date&Time Shift< 1 %
Binary Scorer< 1 %- Fuzzy c-Means< 1 %
- DB Query Reader< 1 %
- Variable Expressions< 1 %
- Table View (JavaScript)< 1 %
- Column Filter Widget< 1 %
- RDKit Descriptor Calculation< 1 %
- Benchmark End< 1 %
- Table Row to Variable< 1 %
- Table Reader< 1 %
- Don't Save Start< 1 %
- Numeric Scorer< 1 %
- Chunk Loop Start< 1 %
Naive Bayes Predictor< 1 %- Add Empty Rows< 1 %
- Category to Number< 1 %
- One to Many< 1 %
- Normalizer< 1 %
- Reference Column Resorter< 1 %
- SDF Reader< 1 %
- Similarity Search< 1 %
List Files< 1 %- Hierarchical Clustering< 1 %
- Association Rule Learner< 1 %
- String to Number (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Table Editor (JavaScript)< 1 %
- Columns to JSON< 1 %
- Modify Date< 1 %
- CASE Switch End< 1 %
- String to Path< 1 %
- RDKit Salt Stripper< 1 %
- URL to File Path (Variable)< 1 %
- Path to String< 1 %
- Column Filter Configuration< 1 %
- Row to Column Names< 1 %
- Create Collection Column< 1 %
CSV Reader< 1 %File Reader< 1 %- Java Snippet< 1 %
- Column List Loop Start< 1 %
- X-Aggregator< 1 %
- Linear Regression Learner< 1 %
- Case Converter< 1 %
- Column Renamer (Dictionary)< 1 %
- Correlation Filter< 1 %
- Table Validator (Reference)< 1 %
- Double to Integer< 1 %
- Constant Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- String Manipulation (Variable)< 1 %
- Statistics< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
Merge Variables< 1 %- Timer Info< 1 %
- Crosstab< 1 %
- Color Manager< 1 %
- Counter Generation< 1 %
- Empty Table Creator< 1 %
Excel Reader (XLS)< 1 %- Java Snippet (simple)< 1 %
- String Matcher< 1 %
- Weka Predictor (3.7)< 1 %
- Column Filter (legacy)< 1 %
- Create Date&Time Range< 1 %
Extract Date&Time Fields< 1 %- Moving Aggregator< 1 %
- RDKit Fingerprint< 1 %
- Substructure Match Counter< 1 %
- Breakpoint< 1 %
- Try (Data Ports)< 1 %
- Column to Grid< 1 %
- Linear Correlation< 1 %
- Nominal Value Row Splitter< 1 %
- Low Variance Filter< 1 %
- Number to String (PMML)< 1 %
String To Number (PMML)< 1 %- Rank< 1 %
- Data Explorer< 1 %
- Box Plot (legacy)< 1 %
- Spark to Table< 1 %
Excel Reader (XLS)< 1 %- Google Sheets Reader< 1 %
- Scatter Plot (JavaScript)< 1 %
- Moving Average< 1 %
- List To Set< 1 %
- Catch Errors (Data Ports)< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
- Recursive Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Table Difference Finder< 1 %
- Extract Table Spec< 1 %
- Merge Variables< 1 %
- Keras Network Executor< 1 %
- Nominal Row Filter Widget< 1 %
Parquet Reader< 1 %- Counting Loop Start< 1 %
- File Reader (Complex Format)< 1 %
- Random Forest Predictor (Regression)< 1 %
- List Files/Folders< 1 %
- Variable Loop End< 1 %
- Line Plot (JavaScript)< 1 %
- String Replacer (Dictionary)< 1 %
- Conditional Box Plot (legacy)< 1 %
Table Writer< 1 %Generic Loop Start< 1 %- Cluster Assigner< 1 %
- Ruleset to Table< 1 %
- Rule Engine (Dictionary)< 1 %
- Extract Table Dimension< 1 %
- Shape Manager< 1 %
- Gaussian Distributed Assigner< 1 %
- Index Query< 1 %
- Weka Cluster Assigner (3.7)< 1 %
Python Script (1⇒1)< 1 %- Fast Fourier Transform (FFT)< 1 %
Interval Loop Start< 1 %- Random Forest Learner (Regression)< 1 %
- Term to String< 1 %
- Boolean Input (legacy)< 1 %
Extract Outer/InnerHTML< 1 %- Run Heavy Garbage Collector< 1 %
- Table Writer< 1 %
- Scorer< 1 %
- SMOTE< 1 %
- Top k Row Filter< 1 %
- Remove Empty Rows< 1 %
- RDKit Substructure Filter< 1 %
- Create Well Position< 1 %
Database Reader< 1 %Line Reader< 1 %PCA< 1 %- Auto-Binner (Apply)< 1 %
- HiLite Row Splitter< 1 %
- Molecule Type Cast< 1 %
Document vector< 1 %- Tags to String< 1 %
- R Snippet< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- RDKit R-Group Decomposition (deprecated)< 1 %
- Google Address Geocoder< 1 %
- Welch Averaging< 1 %
- Binary Objects to Strings< 1 %
- Category to Number (Apply)< 1 %
- Table Validator< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply< 1 %
- Numeric Binner (PMML)< 1 %
CASE Switch Data (End)< 1 %- Save Workflow< 1 %
- Date&Time Input (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Rotate...< 1 %
- Node Adjacency Matrix< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Double Configuration< 1 %
- BCUT< 1 %
- MolConverter< 1 %
- URL to File Path< 1 %
Variable to Table Row< 1 %Database Connection Table Reader< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %- Fuzzy Rule Predictor< 1 %
- Decision Tree Predictor< 1 %
- Distance Matrix Pair Extractor< 1 %
String To Number< 1 %- Many to One< 1 %
Double To Int< 1 %- Denormalizer (PMML)< 1 %
- Parallel Chunk Start< 1 %
- Sentence Extractor< 1 %
- Global Thresholder< 1 %
Python Script (1⇒1)< 1 %- Extract Time Window (legacy)< 1 %
- XML Column Combiner< 1 %
- Text Classifier Predictor< 1 %
- Number Formatter< 1 %
Table Column to Variable< 1 %Parameterized Database Query< 1 %Recursive Loop Start< 1 %Naive Bayes Learner< 1 %- MultiLayerPerceptron Predictor< 1 %
- Logistic Regression Predictor< 1 %
- SVM Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Random Forest Learner< 1 %
- Filter Definition Merger< 1 %
Rank Correlation< 1 %- Parameterized DB Query Reader< 1 %
- DB Writer< 1 %
- TimeDelay Loop Start< 1 %
- DL Python Network Executor< 1 %
- Java IF (Table)< 1 %
- DF< 1 %
- Tika Parser< 1 %
- OpenNLP NE Tagger< 1 %
RDKit Functional Group Filter< 1 %Database Looping< 1 %- Row Splitter (Labs)< 1 %
- CASE Switch Start< 1 %
- Decision Tree View (JavaScript)< 1 %
- InChi< 1 %
- Substructure Matcher< 1 %
Counting Loop Start< 1 %K Nearest Neighbor< 1 %Concatenate (Optional in)< 1 %- Binner (Dictionary)< 1 %
Number To String< 1 %- Set Operator< 1 %
- Shuffle< 1 %
CASE Switch Data (Start)< 1 %- SDF Stripper< 1 %
- Term Co-Occurrence Counter< 1 %
- TF< 1 %
- Punctuation Erasure< 1 %
- Bag Of Words Creator< 1 %
- Google Analytics Query (legacy)< 1 %
- String Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- JSON Row Combiner< 1 %
- Edge Table< 1 %
Python Script (2⇒2)< 1 %- R to Table< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Time Difference (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit From Molecule< 1 %
- HTTP Retriever< 1 %
- Window Slider< 1 %
- Canonical SMILES< 1 %
- Highlighter< 1 %
- Load Text Files< 1 %
Fingerprint Properties< 1 %- Random Numbers Generator< 1 %
- Combine Columns by Header< 1 %
- Normalize Plates (Z-Score)< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Variable to Table Row< 1 %- Fixed Width File Reader< 1 %
Recursive Loop Start (2 ports)< 1 %Variable Loop End< 1 %- Naive Bayes Predictor< 1 %
PCA Compute< 1 %- Entropy Scorer< 1 %
- PCA Apply< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Random Forest Predictor< 1 %
- Bootstrap Sampling< 1 %
- Number to Category (Apply)< 1 %
- Equal Size Sampling< 1 %
- Filter Apply Row Splitter< 1 %
- Interactive HiLite Collector< 1 %
- Many to One (PMML)< 1 %
- Normalizer (PMML)< 1 %
Number To String (PMML)< 1 %- Nominal Probability Distribution Creator< 1 %
- Renderer to Image< 1 %
- Ruleset Editor< 1 %
- Numeric Outliers (Apply)< 1 %
- HiLite Table (legacy)< 1 %
- Parallel Chunk End (multi port)< 1 %
- DB Query Extractor< 1 %
- Random Item Inserter< 1 %
- Random Matcher< 1 %
- TensorFlow Network Executor< 1 %
- TensorFlow 2 Network Executor< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- OpenBabel< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Item Set Finder (Borgelt)< 1 %
- Geo-Coordinate Row Filter< 1 %
Read Excel Sheet Names (XLS)< 1 %- IDF< 1 %
- Keygraph Keyword Extractor< 1 %
- Porter Stemmer< 1 %
- POS Tagger< 1 %
Document Data Extractor< 1 %- Document Vector< 1 %
- Strings to Document< 1 %
- String to Term< 1 %
- Term Neighborhood Extractor< 1 %
- Unique Term Extractor< 1 %
- t-SNE (L. Jonsson)< 1 %
- Union< 1 %
Column Filter Configuration< 1 %- Nominal Row Filter Configuration< 1 %
- Date&Time Configuration< 1 %
- List Box Input (legacy)< 1 %
- List Box Widget< 1 %
- Table to JSON< 1 %
Python Script (2⇒1)< 1 %- Disturber Node< 1 %
- Date&Time to legacy Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Window Loop Start< 1 %
- Time Generator (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Twitter Search< 1 %
- Molecular Properties< 1 %
- SMARTS Query< 1 %
- RDKit Molecule Fragmenter< 1 %
- RDKit To InChI< 1 %
- Speedy SMILES Strip Stereochemistry< 1 %
- Collection Size< 1 %
- List Folders< 1 %
- File Meta Info (legacy)< 1 %
- String to URI< 1 %
Table Column to Variable< 1 %- Line Reader< 1 %
- Interval Loop Start< 1 %
- Recursive Loop Start< 1 %
- Polynomial Regression Learner< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Rule Engine Variable< 1 %
CASE Switch Variable (Start)< 1 %- DB Insert< 1 %
- DB GroupBy< 1 %
- k-Medoids< 1 %
- Category to Class< 1 %
- Value Filter (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- JSON Column Combiner< 1 %
JSON Reader< 1 %- Image to DataRow< 1 %
- Country Extractor< 1 %
- CDK to Molecule< 1 %
- Fingerprints< 1 %
- RDKit R-Group Decomposition< 1 %
- Neo4j Reader< 1 %
- String Similarity< 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_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- Show all 1083 workflows
Links
- Rule Engine Variableby armingrudd on 2020-08-25forum.knime.com/p/100763
- How to Sum Multiple Columnsby izaychik63 on 2021-02-04forum.knime.com/p/114996
- Calulate averageby izaychik63 on 2021-04-23forum.knime.com/p/121767
- how can we match the substring of a stringby izaychik63 on 2021-05-01forum.knime.com/p/122445
- Filter a row if all “Double” or “Integer” columns are 0.by HansS on 2020-11-10forum.knime.com/p/107755
- Show all 24 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.