1.1 - 8.10 - MultiCaseMatch (ML Engine) - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
English (United States)

The MultiCaseMatch function extends the capability of the SQL CASE statement by supporting matches to multiple criteria in a single row.

When SQL CASE finds a match, it outputs the result and immediately proceeds to the next row without searching for more matches in the current row.

The MultiCaseMatch function iterates through the input data set only once and outputs matches whenever a match occurs. If multiple matches occur for a given input row, the function outputs one output row for each match.

Use the MultiCaseMatch function when the conditions in your CASE statement do not form a mutually exclusive set.