Savant

<code>condition1</code>, <code>condition2</code>, <code>...</code>: Conditions to evaluate.

<code>result1</code>, <code>result2</code>, <code>...</code>: Values returned if the corresponding condition is true.

<code>default_result</code>: Value returned if none of the conditions are true (optional).

1. <code>condition1</code>, <code>condition2</code>, <code>...</code>: Conditions to evaluate.
2. <code>result1</code>, <code>result2</code>, <code>...</code>: Values returned if the corresponding condition is true.
3. <code>default_result</code>: Value returned if none of the conditions are true (optional).

Consider a dataset with a column "Price":

Using the <code>CASE...WHEN...</code> statement:

CASE WHEN Price &gt; 1000 THEN 'High-end' WHEN Price &lt;= 1000 AND Price &gt; 200 THEN 'Mid-range' ELSE 'Budget' END

Evaluates conditions and returns a value based on the first true condition

CASE ... WHEN ...

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

Description	The `CASE...WHEN...` statement evaluates multiple conditions and returns a specific value when a condition is met.
Syntax	CASE WHEN `condition1` THEN `result1` WHEN `condition` 2 THEN `result2` ELSE `default_result` END
Output	text

Product	Price
Laptop	1200
Smartphone	800
Headphones	150
Camera	900

Product	Price	Price Category
Laptop	1200	High-end
Smartphone	800	Mid-range
Headphones	150	Budget
Camera	900	Mid-range

Variables

Example