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

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

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