MultiCaseMatch - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
lmf1502735330121
Product Category
Teradata Vantage

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.