How to replace every value in column by the mean of whole column

Hey guys,

i am new to KNIME and i am looking for a way to replace every value in column by the mean of whole column.

I did it with the “constant value column”-node. It works, but when i change by data i obviously need to change the constant value in the node.

So i am looking for a solution, which works and does not require a chnage of the node when i change my data.

Many thanks in advance!

Hi @quique and welcome

You can use the COL_MEAN(col_name) function from the Math Formula node . And then choose Replace Column .

gr. Hans

4 Likes

Hi @HansS,

That’s exactly what i was looking for. Thank you very much and have a nice weekend!

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.