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.

KNIME Analytics Platform
3

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