Missing Value Node not showing blank fields with red checkmarks

Hi,
My Missing Value Nodes is not populating the missing values. The reason is because it is not showing my blank fields with red checkmarks. How can I get the red checkmarks to populate?
Thanks
Scott

I may be able to resolve this using the string manipulation node?

In the past, I’ve been able to convert blank cells to missing values with the Column Expressions node:

if (length(column("your_column_name")) == 0){
    missingValue();
}
else
{ column("your_column_name");
}

Thanks elsamuel I will give it a try.

Hi @sgilmour,

you can use toNull() function from String Manipulation node to replace empty string with missing value. If you have to do so for multiple columns use String Manipulation (Multi Column) node. How did you end up with a empty string?

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.