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