how to match missing values in rule engine

i have a recursive loop that i need to stop when a certain variable is missing aka null
how would i write that in a rule engine node
i searched around and i found MISSIN $${svariable}$$ but it didnt work please help me

i searched around and i found MISSIN $${svariable}$$ but it didnt work please help me

  1. Is this a typo?
  2. The MISSING operator requires a column as the argument, not a variable.

You could try the Column Expressions node with the isMissing function, but I think you’re going to have a hard time with using a variable.

Have you tried matching the actual value of the string variable, which is going to be “missing” when it’s a string?

2 Likes

thank you so much, it was my bad what i did was convert the row that column into a row variable which messed up my MISSING operator i fixed it thank you

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.