Replacing invalid values

Replace invalid values with a placeholder valid value to avoid errors.

1. Right-click ProbeTempF in the cleansed element and click Remove Expressions (Mappings).
2. Drag and drop an IfThenElse function in its Value tab.

   

3. Drop an Equal function on the Condition argument.
4. Drag and drop the ProbeTempF element from the input structure on the First Value argument.
5. Drop a Constant function on the Second Value argument and set its value as N/C.
6. Drop a Constant function on the Then argument and set its value as 0.
7. Drag and drop the ProbeTempF element from the input structure on the Else argument.
8. Save your map.

Results

You have configured your map to replace all N/C values in ProbeTempF with 0 in the cleansed output. The Value tab should look like this: