Replacing Zeros with Avg from other rows

[mlauber71]

You could use this concept of moving average but use it to calculate the avg value without the missing or zeros. And then replace them with the avg value using a Rule Engine

Cumulative sum with a condition

Hi @tomekk! Don’t get discouraged! It can be pretty simple with KNIME. Like this: [GroupCumulativeSum] In case I haven’t missed something of course And don’t hold it against @armingrudd and @mlauber71. They like KNIME nodes so much they can’t get enough of it Now you can use some rule based node to see which invoice exceeded a certain project sum 2019_01_23_Group_Cumulative_Sum.knwf (15.8 KB) Have a nice day, Ivan

Replace missing data baed on mean of alternative column

hi there I would use the group by node to group by "new.title" and getting the mean for "age". having theses numbers, got to the main table and use the rule engine node and set it like: $new.title$ LIKE "master"  AND MISSING $age$ => 888 $new.title$ LIKE "mrs"  AND MISSING $age$ => 888 $new.title$ LIKE "XYZ"  AND MISSING $age$ => 888 where 888 is your dedicated mean that you got from the group by node..   NOTE you have to set the rule engine node to replace column age   good luck!