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.

Signature

caseWhen(booleanExpr1, valueIfExpr1True, booleanExpr2, valueIfExpr2True) caseWhen(booleanExpr1, valueIfExpr1True, booleanExpr2, valueIfExpr2True, ... ,valueIfFalse)

ArgumentsDescription

booleanExpr1

A boolean expression

valueIfExpr1True, valueIfExpr2True

A value to return.

Usage Examples

The usage examples are based on extracting fields from the following JSON documents:

{
  "latitude": 1.0
}
ExpressionValue

CASEWHEN(latitude > 0, 'North', 'South')

North

CASEWHEN(latitude > 0, 1, 0)

1

This function can be used in the table config to add northernHemisphere column:

{
   "tableConfig":{
      "ingestionConfig":{
         "transformConfigs":[
            {
               "columnName":"northernHemisphereStr",
               "transformFunction":"CASEWHEN(latitude > 0, 'North', 'South')"
            }
         ]
      }
   }
}