caseWhen
This section contains reference documentation for the caseWhen function.
Returns values depending on boolean expressions. This function can only be used in an ingestion transformation function.
caseWhen(booleanExpr1, valueIfExpr1True, booleanExpr2, valueIfExpr2True) caseWhen(booleanExpr1, valueIfExpr1True, booleanExpr2, valueIfExpr2True, ... ,valueIfFalse)
Arguments | Description |
---|---|
booleanExpr1 | A boolean expression |
valueIfExpr1True , valueIfExpr2True | A value to return. |
The usage examples are based on extracting fields from the following JSON documents:
{
"latitude": 1.0
}
Expression | Value |
---|---|
CASEWHEN(latitude > 0, 'North', 'South') | North |
CASEWHEN(latitude > 0, 1, 0) | 1 |
{
"tableConfig":{
"ingestionConfig":{
"transformConfigs":[
{
"columnName":"northernHemisphereStr",
"transformFunction":"CASEWHEN(latitude > 0, 'North', 'South')"
}
]
}
}
}
Last modified 5mo ago