Coalesce
Description
The Coalesce transform lets you list multiple fields and returns the first non-null value.
Options
| Option | Description |
|---|---|
Transform name | Name of the transform. Note: This name has to be unique in a single pipeline. |
Considered empty string as null | The transform can consider empty string as null. |
Fields
|Fields|specify the name, type, and value in the form of a string. Then, specify the formats to convert the value into the chosen data type.
| Name | The result field name, can overwrite an existing one. |
|---|---|
Type | The formats to convert the value into the chosen data type. |
Remove | Remove input fields from the stream. |
Input fields | The order of the input fields listed in the columns determines the order in which they are evaluated. |
| Support MetaData Injection (MDI) |