You are here:
Using the Case Node
The case node, similar to the CASE statement in SQL, analyzes data by comparing the attributes of conditions. The WHEN/THEN statements determine the outcome based on whether all or any of the specified conditions are true. If none of the WHEN conditions are met, the ELSE statement provides an alternative action. The Case node statement must be followed by at least one WHEN/THEN pair, which applies a designated function when the associated condition is true.
| equal | Returns values that are equal to the specified value. |
| not | Returns values that are not equal to the specified value. |
| is null | Returns a null value when conditions are met. |
| is not null | Returns a not null value when conditions are met. For example, filtering a field to ensure that the value exists. |
| less than | Returns values that are less than the specified value. |
| less than or equal to | Returns values that are less than or equal to the specified value. |
| greater than | Returns values that are greater than the specified value. |
| greater than or equal to | Returns values that are greater than or equal to the specified value. |
| is empty | Returns empty values. For example, an empty string is a string with zero length. |
| contains | Checks if the given value can be found in the results. |
| does not contain | Checks whether the specified value is not present in the results. |
| contains regular expression | Checks whether the specified matching string is present in the results. |
| does not contain regular expression | Checks whether the specified matching string is not present in the results. |
Did this article solve your issue?
Let us know so we can improve!
