NULL_IF
If there is a 'true' boolean value in the 'condition' parameter, then return null. Otherwise, return the second argument
Syntax
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' |
|
null::boolean | 'foo' |
|
Transformation job example
SQL
Query result
condition | value | Output |
---|---|---|
true | 'foo' | null |
Last updated