Expand description
SQL-style CASE WHEN: evaluates (condition, value) pairs in order and returns
the value from the first matching condition (first-match-wins). NULL conditions
are treated as false. If no ELSE clause is provided, unmatched rows produce NULL;
otherwise they get the ELSE value.
Unlike SQL which coerces all branches to a common supertype, all THEN/ELSE branches must share the same base dtype (ignoring nullability). The result nullability is the union of all branches (forced nullable if no ELSE).
The serialized expression format is not part of a Vortex edition and is not guaranteed to remain compatible across Vortex versions.
Structsยง
- Case
When - An n-ary CASE WHEN expression.
- Case
When Options - Options for the n-ary CaseWhen expression.