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”
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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.