IF_ELSE
If there is a true Boolean value in the condition parameter, then return the second argument; in all other cases, return the third argument
Syntax
Arguments
Name | Type | Description | Default Value |
---|---|---|---|
condition | Boolean | If this is true, return the second argument, otherwise return the third argument. | |
true_value | any | The value to return when the condition is true | |
false_value | any | The value to return when the condition is not true |
Examples
condition | true_value | false_value | Output |
---|---|---|---|
true | 'foo' | 'bar' |
|
false | 'foo' | 'bar' |
|
null::Boolean | 'foo' | 'bar' |
|
Transformation job example
SQL
Query result
condition | true_value | false_value | Output |
---|---|---|---|
true | 'foo' | 'bar' |
|
Last updated