I want to replace the NULL value to “0” in the culumn “<=2000kbps+Count(gNodeB Name)”, but it can not work, I have tried Rule Engine Node, but below expression cannot work.

I want to replace the NULL value to “0” in the culumn “<=2000kbps+Count(gNodeB Name)”, but it can not work, I have tried Rule Engine Node, but below expression cannot work.
$<=2000kbps+Count(gNodeB Name)$ =“” => “0”

3

I have solved this issue of NULL value to 0 , add Missing Value Node.
7

result as below

1 Like

Hi @cghw62382 , I’m glad to hear you found a solution with the Missing Value node.

For future reference, the Rule Engine can achieve it, but a missing value is not the same as an empty string. Instead you need to use the MISSING keyword as below. For completeness I’ve also given a rule for when the column value is not missing (assuming this might occur):

MISSING $<=2000kbps+Count(gNodeB Name)$ => “0”
TRUE => $<=2000kbps+Count(gNodeB Name)$
4 Likes