Coalesce - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The standard COALESCE case expression is supported, generating SQL of the form COALESCE (expression, …expression). It must be supplied at least two arguments. The entire COALESCE expression will automatically be enclosed in parentheses if it is not part of an expression and not already enclosed in parentheses. When dragging a Coalesce into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Case > Coalesce

Multiple expressions can be built up within the Expressions folder.
COALESCE can be used in place of the non-standard Teradata specific command ZEROIFNULL. For example, COALESCE(column1, 0) is equivalent to ZEROIFNULL(column1).

There are no special properties for the Coalesce function.