Berserk Docs
Scalar FunctionsConditional Functions

case

Evaluates predicates in order and returns the first matching value.

Syntax

case(args)

Parameters

Prop

Type

Returns: dynamic

Examples

Example 1 — Three-tier ranking with an else clause

print case(42 > 30, "jarl", 42 > 10, "karl", "thrall")
print_0 (string)
jarl

Example 2 — Four tiers applied to a table

datatable(warrior:string, voyages:long)[
  "Ragnar", 42,
  "Bjorn", 31,
  "Floki", 8,
  "Ivar", 22
]
| extend rank = case(
  voyages > 35,
  "jarl",
  voyages > 20,
  "karl",
  voyages > 10,
  "huskarl",
  "thrall"
)
warrior (string)voyages (long)rank (string)
Bjorn31karl
Floki8thrall
Ivar22karl
Ragnar42jarl

series_sum

Returns the sum of all elements in a numeric series, ignoring null values.

coalesce

Returns the first non-empty value (not null and not empty string).

On this page

SyntaxParametersExamplesExample 1 — Three-tier ranking with an else clauseExample 2 — Four tiers applied to a table