Conditional Statements

The conditional statements are functions that select an expression to return depending on a conditional expression.

Function Signature Description
if() if (bool exp, exp1, exp2) Test for a condition, returning one of two values
case() case(. . ., bool exprN, resultN, else) Test for a condition, returning one of two or more values
decode() decode(field, caseValue, thenValue, elseValue) Test for a condition, returning one of two or more values
caseContains() caseContains(string field, string caseValue, string thenValue, ..., string elseValue) Test for a condition, returning one of two or more string values
caseContains() caseContains(string field, boolean caseSensitive, string caseValue, string thenValue, ..., string elseValue) Test for a condition, returning one of two or more case sensitive string values