How to check whether a specific column exists in a table, for example, whether the student name exists in the table?

[takbb]

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.

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)$