missing values

[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…