Coalesce (Any value1, Any value2)

Name

Coalesce

Syntax

Coalesce (Any value1, Any value2)

Purpose

To return first non-null value in order of the parameters specified.

Description

Returns the first non-null value from specified parameters. Returns null if both parameters are null.

Return Type

Object

Parameters

value1 [System.Object] – First expression

value2 [System.Object] – Second expression

Example

We have a Customers dataset, with missing values in the Items and ShipCountry fields, which we will use for this function.

We will map these fields to value1 and value2 of the function transformation object.

Where,

value1 = Items

value2 = ShipCountry

Then, we will map the Output value field of the function transformation object and the remaining fields from our source file to an Excel Workbook Destination.

Right-click on the Excel Workbook Destination object and select Preview Output. You can see that Astera Data Stack has created a new column, and returned a value from either Items (value1), ShipCountry (value2), or null (if both specified parameters are null), in this particular order.

© Copyright 2023, Astera Software