This node calculates aggregation values for a moving window. The aggregation values are displayed in new columns appended at the end of the table.
The columns to aggregate can be either defined by selecting the columns directly, by name based on a search pattern or based on the data type. Input columns are handled in this order and only considered once e.g. columns that are added directly on the "Manual Aggregation" tab are ignored even if their name matches a search pattern on the "Pattern Based Aggregation" tab or their type matches a defined type on the "Type Based Aggregation" tab. The same holds for columns that are added based on a search pattern. They are ignored even if they match a criterion that has been defined in the "Type Based Aggregation" tab.
The "Manual Aggregation" tab allows you to change the aggregation method of more than one column. In order to do so select the columns to change, open the context menu with a right mouse click and select the aggregation method to use.
In the "Pattern Based Aggregation" tab you can assign aggregation methods to columns based on a search pattern. The pattern can be either a string with wildcards or a regular expression. Columns where the name matches the pattern but where the data type is not compatible with the selected aggregation method are ignored. Only columns that have not been selected as aggregation column on the "Manual Aggregation" tab are considered.
The "Type Based Aggregation" tab allows to select an aggregation method for all columns of a certain data type e.g. to compute the mean for all decimal columns (DoubleCell). Only columns that have not been handled by the other tabs e.g. column based and pattern based are considered. The data type list to choose from contains basic types e.g String, Double, etc. and all data types the current input table contains.
A detailed description of the available aggregation methods can be found on the 'Description' tab in the node dialog.
Options
General settings
Manual Aggregation
Pattern Based Aggregation
Type Based Aggregation
Aggregation settings
Popular Successors
Column Rename6 %- Math Formula4 %
- Loop End4 %
- Column Renamer3 %
CSV Writer3 %- Rule Engine2 %
- Moving Aggregator2 %
- Rule-based Row Splitter1 %
- Line Plot1 %
- Math Formula (Multi Column)1 %
Row Filter (deprecated)1 %Column Appender1 %Loop End1 %- Lag Column1 %
Linear Correlation1 %- Java Snippet Row Filter< 1 %
- Table Transposer< 1 %
- Line Plot (Plotly)< 1 %
- GroupBy< 1 %
- Joiner< 1 %
- String to Number< 1 %
- Rank< 1 %
- End IF< 1 %
- Time Difference (legacy)< 1 %
- Linear Regression Learner< 1 %
- Column Filter< 1 %
- Table Manipulator< 1 %
- Group Loop Start< 1 %
- Constant Value Column< 1 %
- String Manipulation< 1 %
- Scatter Plot (Plotly)< 1 %
- Regression Predictor< 1 %
- Concatenate< 1 %
- Column Resorter< 1 %
- Excel Writer< 1 %
- R View (Table)< 1 %
- String to Date&Time< 1 %
- Java Snippet< 1 %
- Chunk Loop Start< 1 %
- Recursive Loop End< 1 %
- k-Means< 1 %
- Numeric Scorer< 1 %
- Column Combiner< 1 %
- Linear Correlation< 1 %
- RowID< 1 %
- Ungroup< 1 %
- Capture Workflow End< 1 %
- Column Expressions< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Line Plot (JavaScript)< 1 %
- Table Row to Variable Loop Start< 1 %
String To Number< 1 %- Duplicate Row Filter< 1 %
- Rule-based Row Filter< 1 %
- Counter Generation< 1 %
- Scatter Plot (JavaScript)< 1 %
- Date&Time Shift< 1 %
Variable to Table Column< 1 %- Table Row to Variable< 1 %
- Column List Loop Start< 1 %
- Column Appender< 1 %
- Column Name Extractor< 1 %
- Cross Joiner< 1 %
- Missing Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Row Filter (Labs)< 1 %
- Reference Row Filter< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Sorter< 1 %
- Column Splitter< 1 %
- Top k Row Filter< 1 %
- Color Manager< 1 %
- Bar Chart (JavaScript)< 1 %
- Line Chart (JFreeChart)< 1 %
- Data to Report (BIRT)< 1 %
- Date&Time Difference< 1 %
- Extract Duration Fields< 1 %
- Modify Time< 1 %
- Window Loop Start< 1 %
- Mask Date/Time (legacy)< 1 %
- ARIMA Visualization< 1 %
- Split Collection Column< 1 %
- Catch Errors (Data Ports)< 1 %
- Variable to Table Column< 1 %
- CSV Writer< 1 %
- Loop End (Column Append)< 1 %
- Counting Loop Start< 1 %
Recursive Loop End (2 ports)< 1 %- Association Rule Learner< 1 %
- Random Forest Predictor (Regression)< 1 %
- Numeric Binner< 1 %
Cell Replacer< 1 %Cell Splitter< 1 %- Cell Splitter< 1 %
- Column Comparator< 1 %
Number To String< 1 %- Number to String< 1 %
- Column Aggregator< 1 %
- Column Rename (Regex)< 1 %
- One to Many< 1 %
- Reference Column Filter< 1 %
- HiLite Row Splitter< 1 %
Joiner< 1 %- Normalizer< 1 %
- Partitioning< 1 %
- Number Rounder< 1 %
- Unpivot< 1 %
- Interactive Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Bar Chart< 1 %
- Table View< 1 %
- DB Writer< 1 %
- Error Bars Plot (Plotly)< 1 %
- Java Snippet (simple)< 1 %
- Date&Time Input (legacy)< 1 %
- R Snippet< 1 %
- Duration to Number< 1 %
Extract Date&Time Fields< 1 %- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Moving Average< 1 %
- ARIMA Predictor< 1 %
Table Row to Variable< 1 %- Table Creator< 1 %
- Polynomial Regression Learner< 1 %
- PCA< 1 %
Concatenate (Optional in)< 1 %- Nominal Value Row Filter< 1 %
- Reference Row Splitter< 1 %
- Numeric Outliers< 1 %
- Crosstab< 1 %
- Interactive Histogram (legacy)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Python Script (legacy)< 1 %
Map Viewer< 1 %Table Writer< 1 %- Java Edit Variable< 1 %
- Edit Numeric Domain< 1 %
- Extract Missing Value Cause< 1 %
CASE Switch Data (End)< 1 %Color Appender< 1 %- ROC Curve (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Slider Widget< 1 %
- Container Output (JSON)< 1 %
- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
Regex Extractor< 1 %- Combine Columns by Header< 1 %
- ARIMA Learner< 1 %
Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Recursive Loop End< 1 %Recursive Loop Start< 1 %- Fuzzy c-Means< 1 %
Regression Predictor< 1 %Numeric Scorer< 1 %- Row Splitter (Labs)< 1 %
- String Splitter (Regex)< 1 %
- String Manipulation (Variable)< 1 %
- Statistics< 1 %
- IF Switch< 1 %
- Histogram (legacy)< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Table to H2O< 1 %
- Send to Power BI< 1 %
- Strings to Document< 1 %
- Date&Time to String< 1 %
- Extract Time Window (legacy)< 1 %
- Time Domain Features (TDF)< 1 %
- Price War< 1 %
- Timed Loop End (1 port)< 1 %
- Collection to String< 1 %
- Outlier Removal< 1 %
- R Snippet< 1 %
- R Plot< 1 %
- R Snippet (2:1)< 1 %
- Breakpoint< 1 %
- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Database Looping< 1 %- Table Writer< 1 %
- Feature Selection Filter< 1 %
Counting Loop Start< 1 %Generic Loop Start< 1 %Recursive Loop Start (2 ports)< 1 %- X-Aggregator< 1 %
- X-Partitioner< 1 %
- Decision Tree Predictor< 1 %
- Logistic Regression Learner< 1 %
- Logistic Regression Predictor< 1 %
Scorer< 1 %- SMOTE< 1 %
- SVM Learner< 1 %
Tree Ensemble Predictor (Regression)< 1 %Gradient Boosted Trees Predictor< 1 %- Random Forest Predictor< 1 %
- Add Empty Rows< 1 %
- Auto-Binner< 1 %
- Binner (Dictionary)< 1 %
- Create Bit Vector< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Domain Calculator< 1 %
- Double to Integer< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Low Variance Filter< 1 %
- Normalizer (Apply)< 1 %
- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Row Sampling< 1 %
- Shuffle< 1 %
- String Manipulation (Multi Column)< 1 %
- Value Counter< 1 %
- Renderer to Image< 1 %
- Rule Engine (Dictionary)< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- Independent groups t-test< 1 %
- Linear Discriminant Analysis< 1 %
- CASE Switch End< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Timer Info< 1 %
- Box Plot (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Table to Spark< 1 %
- Parallel Chunk End< 1 %
- Gaussian Distributed Assigner< 1 %
- One Row to Many< 1 %
- Time Series Generator< 1 %
- Numeric Distances< 1 %
- String Distances< 1 %
- Matrix Distance< 1 %
K Nearest Neighbor (Distance Function)< 1 %- Math Formula (Variable)< 1 %
- Bar Chart (JFreeChart)< 1 %
- Geo-Coordinate Row Filter< 1 %
XLS Sheet Appender< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Spark Line Appender< 1 %
Document Data Extractor< 1 %- Google Sheets Appender< 1 %
- Column Filter (legacy)< 1 %
- Lift Chart (JavaScript)< 1 %
JSON Writer< 1 %MongoDB Reader< 1 %Python View< 1 %Python Script (1⇒1)< 1 %- Table to R< 1 %
- GET Request< 1 %
- Table Difference Checker< 1 %
- Create Date&Time Range< 1 %
- Modify Date< 1 %
- Time Field Extractor (legacy)< 1 %
- Time to String (legacy)< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 00 Send Reporting_vMediumKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 01 - Email Database Data PreparationKNIME Hub
- Show all 550 workflows
Links
- RECURSIVE CALCULUSby izaychik63 on 2024-09-23forum.knime.com/p/270057
- Cumulative ROW SUM With Multiple Conditions HELP PLEASEby izaychik63 on 2019-10-28forum.knime.com/p/73452
- Cumulative sum with a conditionby armingrudd on 2019-01-23forum.knime.com/p/53336
- Get Timestamp for each Ranked Valueby buechertasche123 on 2020-03-10forum.knime.com/p/83902
- How to update a value between row iterationsby armingrudd on 2022-07-28forum.knime.com/p/164712
- Show all 9 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.