How to calculate mean in GROUP BY node

I wanted to find the mean after grouping the external id. But I can’t seem to find “mean” in the aggregation list under manual aggregation. Now, they are all listed and I want to find the mean of the list. What should I do?

‘Mean’ is only there if your column is a numerical column. Try the String to Number node before your GroupBy - https://nodepit.com/node/org.knime.base.node.preproc.colconvert.stringtonumber.StringToNumberNodeFactory

Steve

2 Likes

Thank you!! I did it

1 Like