Have you ever struggled to get the exact output that you need from a column in Alma Analytics? "CASE" statements are a flexible solution in many situations, allowing one to tailor the output with precision. This presentation will discuss specific strengths of CASE, such as: using CASE to "bin" values with efficient syntax, producing numerical values for logical operations, returning mixed data types, and nesting CASE statements.
Duluth Ex Libris Knowledge Days and ELUNA Events 2024 eluna-conf-planning@exlibrisusers.orgHave you ever struggled to get the exact output that you need from a column in Alma Analytics? "CASE" statements are a flexible solution in many situations, allowing one to tailor the output with precision. This presentation will discuss specific strengths of CASE, such as: using CASE to "bin" values with efficient syntax, producing numerical values for logical operations, returning mixed data types, and nesting CASE statements.