Row Aggregator

Aggregate columns using an aggregation function. The rows can optionally be grouped by a category column. Some aggregation functions support using a weight from a weight column.
If you need more sophisticated functionality, you can use the GroupBy node.

Options

Category column

Select the column that defines the category on which rows are grouped. If no category column is selected, "grand total" values in which all rows belong to the same group will be calculated.

Aggregation

Select the aggregation function to be applied on all rows belonging to the same category.

• Occurrence count: Count how many rows occur
• Sum: Sum up values, optionally weighted by the value from the weight column
• Average: Calculate the mean value, optionally weighted by the value from the weight column
• Minimum: Calculate the minimum value
• Maximum: Calculate the maximum value

Aggregation columns

Select the columns to apply the aggregation function to.

Weight column

Select the column that defines the weight with which a value is multiplied before aggregation. Note, that only the aggregation functions "Sum" and "Average" support a weight column

Additional "grand totals" at second output port

If a category column is selected, additionally compute the aggregations without the category column ("grand totals") and output them in the second output table. The second output is inactive if no category column is selected or this setting is not enabled.

Enable Hiliting

Enable hiliting between the input port and the aggregated output table.

Views

This node has no views

Workflows

• 00_Combine_Clean_and_Summarize_Spreadsheet_DataKNIME Hub
• 01_ ExercisesKNIME Hub
• 01_Flow Variable and Component - ExerciseKNIME Hub
• 01_Flow Variable and Component - ExerciseKNIME Hub
• 01_Flow Variable and Component - ExerciseKNIME Hub
• Show all 382 workflows

Links

• No links available

Developers