I am trying to aggregate data in KNIME and trying to use the Group By node. However, I can’t get the node to work.
Can someone explain what is the best way to use the node? I have over 20 columns and want to group the data by year. What is the difference between the Groups and Manual Aggregation options?
Here is a screenshot.
Group is for the key column which should be kept and where you want to aggregate over it. in you example Year.
In the manual Aggregation option you have to define for each column which aggregation calculation you want to apply (e.g. count, average, minimum, maximum, etc.). You can also define different aggregation calculations for one column.
Super helpful. Thank you for this.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.