Switch

Description

Emulates the MS Access SWITCH function.
Evaluates a list of (up to 20) expressions and returns the value associated with the first expression in the list that is True.
If no expressions evaluate as true, the function returns null.

Syntax

SWITCH(<XPN1>, <ValueIfXPN1True>, [XPN2], [ValueIfXPN2True], ... [XPN20], [ValueIfXPN20True])

Arguments

Argument Type Description Optional
XPN1 Yes/No Value to evaluate as true/false No
ValueIfXPN1True Any Value to return if XPN1 is true No
XPN2 Yes/No Value to evaluate as true/false Yes
ValueIfXPN2True Any Value to return if XPN2 is true Yes – if XPN2 not set
…
XPN20 Yes/No Value to evaluate as true/false Yes
ValueIfXPN20True Any Value to return if XPN20 is true Yes – if XPN20 not set

Returns

Any

Examples

Expression:
SWITCH(
Source.Age >= 1 AND Source.Age <= 16, "Up to 16", Source.Age >= 17 AND Source.Age <= 18, "17 - 18", Source.Age >= 19 AND Source.Age <= 25, "19 - 25", Source.Age >= 26 AND Source.Age <= 35, "26 - 35", Source.Age >= 36 AND Source.Age <= 45, "36 - 45", Source.Age >= 46 AND Source.Age <= 55, "46 - 55", Source.Age >= 56 AND Source.Age <= 65, "56 - 65", Source.Age >= 66, "66+",
TRUE, 'Prefer not to say'
)
Returns: When Source.Age = 30: “26 – 35”

Download

Download Example