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

  • White Facebook Icon
  • White Twitter Icon
  • White Instagram Icon
  • White YouTube Icon

© 2023 by Random Musings. Proudly created with Wix.com.

bottom of page