when

function when(condition, value): WhenBuilder;

Defined in: functions/conditional.ts:19

Begins a CASE WHEN chain. Use .when() / .otherwise() on the result.

Parameters

Parameter	Type
condition	Column
value	Column

Returns

WhenBuilder

Example

when(col("age").gt(lit(18)), lit("adult"))
    .when(col("age").gt(lit(12)), lit("teen"))
    .otherwise(lit("child"))