How do i average a column to become one number only

preeti5 · August 2, 2020, 4:02am

The column in grey how do i make it into just 1 number like in excel you can do that…how can i do this in knime?

armingrudd · August 2, 2020, 5:58am

If you need the average in a single cell use the GroupBy node and add the column(s) in one of the aggregation tabs with “Mean” method.

If you need to retain rows, use COL_MEAN() function in Math Formula or Math Formula (Multi Column) nodes.

davidlan · January 19, 2023, 8:42pm

Quick question, does COL_MEAN() function or equivalent available in the Column Expression node? I have looked in “FUNCTION” but couldn’t find it. Sorry I am very new to Knime.

ipazin · January 20, 2023, 9:45am

Hello @davidlan,

don’t think there is. Actually, think there’s no function in Column Expressions node that works on entire column values.

Br,
Ivan