top of page
Use the CASE Statement to convert data elements:
​
​
Add a field in your DataSource to use the CASE function.
​
Sample:
​
CASE
WHEN REGEXP_MATCH(Grade_Level, "9") THEN "Freshman"
WHEN REGEXP_MATCH(Grade_Level, "10") THEN "Sophomore"
ELSE "Other"
END
CASE
WHEN REGEXP_MATCH(Grade_Level, "9") THEN "Freshman"
WHEN REGEXP_MATCH(Grade_Level, "10") THEN "Sophomore"
ELSE "Other"
END
bottom of page