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
.equals compares this number to a specific one (Double.NaN) is the number we want to compare our input to (in this case a special notation for NaN)
? offers two options, if the previous test is true, i.e. your number is an NaN then null is returned, which will be interpreted as a missing value, otherwise your input number will be returned, i.e. only NaN will be replaced and nothing else will be affected.
I also appended a screenshot. Hope this helps you.
