Was this helpful?
Was this helpful?
Returns values depending on boolean expressions. This function can only be used in an .
caseWhen(booleanExpr1, valueIfExpr1True, booleanExpr2, valueIfExpr2True) caseWhen(booleanExpr1, valueIfExpr1True, booleanExpr2, valueIfExpr2True, ... ,valueIfFalse)
The usage examples are based on extracting fields from the following JSON documents:
This function can be used in the to add northernHemisphere
column:
This section contains reference documentation for the caseWhen function.
booleanExpr1
A boolean expression
valueIfExpr1True
, valueIfExpr2True
A value to return.
CASEWHEN(latitude > 0, 'North', 'South')
North
CASEWHEN(latitude > 0, 1, 0)
1