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.