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.
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
