1. Home
  2. On-premises 5.2
  3. Guides
  4. Tours
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Connectors
    3. Built-in Functions
      1. Aggregation Functions
      2. Analytic Functions
      3. Boolean Functions
      4. Conditional Statements
      5. Conversion Functions
      6. Filter Functions
      7. Miscellaneous Functions
      8. Arithmetic Functions
      9. Date Functions
      10. String Functions
    4. Incorta Connector SDK
    5. Security
    6. Visualizations
    7. Other
  8. Integrations
  9. Data applications
  10. Releases

Conditional Statements

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

FunctionSignatureDescription
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