1 of 1

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)

Arguments

Description

Usage Examples

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

Expression

Value

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

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)

Arguments

Description

Usage Examples

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

Expression

Value

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

valueIfExpr1True, valueIfExpr2True

{
  "latitude": 1.0
}

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

{
  "latitude": 1.0
}

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

caseWhen

hashtagSignature

hashtagUsage Examples

caseWhen

hashtagSignature

hashtagUsage Examples

Signature

Usage Examples

Signature

Usage Examples