missing values

[Mohamed_Alsanus]

hello
i don’t know if it is possible to do it, but i have column with some missing values
i want to fill these values one by one, by taking in account the value added in the previous cell
to explain more
2010 5
2011 8
2012 10
2013 NA
2014 NA
2015 18
so i want to fill the 2013 value but when filling the 2014 it should take the 2013 value too

[HansS]

Hi @Mohamed_Alsanus

You can use the Missing Value node for this. There is an option to fill in the missings with the Previous (non missing) Value.

Beware that this only apply to missing value as KNIME sees missing values, so cells filled with ?.

gr. Hans

[rfeigel]

Check out the second (Rule Engine) suggestion in this post.

Nan to Missing Value

Hello Claudette, I assume that your column is a Numeric (Double) one. You can use the Java Snippet Node to achieve that. Assuming your column is called ‘MyDoubleCol’ you can use this simple line of code to change NaN to missing values: out_double = c_MyDoubleCol.equals(Double.NaN) ? null : c_MyDoubleCol; Explanation: out_double is your output column (in this case a new one, but you can also replace MyDoubleCol). c_MyDoubleCol is your value of MydoubleCol that shall be checked for NaN .eq…