...
COALESCE Arguments | Result |
---|---|
coalesce(NULL, 12, NULL)1 | 2 |
coalesce(1, NULL, NULL) | 1 |
coalesce(NULL, NULL, 3) | 3 |
coalesce(NULL, NULL, NULL) | NULL |
...
Snap Type
ELT Coalesce Snap is a TRANSFORM-type Snap that extracts non-NULL values from datasets containing NULL values.
Prerequisites
A valid SnapLogic account to connect to the database in which you want to perform the COALESCE operation.
...