NULL_IF
If there is a true Boolean value in the condition parameter, then return null; otherwise, return the second argument
Syntax
NULL_IF(condition, value)
Arguments
| Name | Type | Description | Default Value |
|---|---|---|---|
| condition | Boolean | If this is true, return null. Otherwise, return the second argument | |
| value | any | This will be returned as-is if the first argument does not contain true. |
Examples
| condition | value | Output |
|---|---|---|
| true | "foo" | null |
| false | "foo" | foo
|
| null::Boolean | "foo" | foo
|