Coalesce (Any value1, Any value2)

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