Convert to Null

Hello @Ammar_74
A useful one is with the ‘Rule Engine’ node; uncomplete definition of rules leads to missing values…

By typical way of coding, you give a code line for no specific rules like…

$occupation$ LIKE "___" => ""
TRUE => $occupation$

this will return empty values but not missed as your requirement.
[…]

But if you code in this way, it will return the nulls (missing) that you look for:

NOT $occupation$ LIKE "___" => $occupation$

this code example will return nulls for your use case, I haven’t tested it but I think that it will work.

BR

3 Likes