I am currently stuck on this problem with replacing blank cells with missing values or an integer.
In this example I split the rows based on this GG level to find the count within each level.
Based on different data sets, the GG level(s) may or may not have rows to filter. In the instance that there aren’t any rows to filter, I would like to find a way to replace the empty data table with missing values or an integer.
What is the best way to go about this? I’ve tried using the Column Auto Type Cast node and String Manipulation’s toNull() function, but no success. I hope that someone here can help me out.
Hi @Ammar_Muhammad , there is a toNull() function in the Column Expressions node or in the String Manipulation node too. Please read the documentation about how to use the function (you can click on the function in either node to see how to use it)