How do i average a column to become one number only

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?

Hi @preeti5,

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.



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.

Hello @davidlan,

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