MultiCaseMatch Example - Teradata Vantage

This example labels people with the age groups to which they belong, which overlap:

Input

SQL Call

SELECT * FROM MultiCaseMatch (
  ON (SELECT t.*,
    (CASE WHEN t.age < 1 THEN '1' ELSE '0' END) AS case1,
    (CASE WHEN t.age >= 1 and t.age <= 2 THEN '1' ELSE '0' END) AS case2,
    (CASE WHEN t.age >= 2 and t.age <= 12 THEN '1' ELSE '0' END) AS case3,
    (CASE WHEN t.age >= 13 and t.age <= 19 THEN '1' ELSE '0' END) AS case4,
    (CASE WHEN t.age >= 16 and t.age <= 25 THEN '1' ELSE '0' END) AS case5,
    (CASE WHEN t.age >= 21 and t.age <= 40 THEN '1' ELSE '0' END) AS case6,
    (CASE WHEN t.age >= 35 and t.age <= 60 THEN '1' ELSE '0' END) AS case7,
    (CASE WHEN t.age >= 60 THEN '1' ELSE '0' END) AS case8
    FROM people_age AS t
  )
  USING
  Labels (
    'case1 AS "infant"',
    'case2 AS "toddler"',
    'case3 AS "kid"',
    'case4 AS "teenager"',
    'case5 AS "young adult"',
    'case6 AS "adult"',
    'case7 AS "middle aged person"',
    'case8 AS "senior citizen"'
  )
) AS dt;

Output

Several people have two labels. For example, Freddy is both a toddler and a kid, and Tom Sawyer and Becky Thatcher are both teenagers and young adults.