Coalesce

Description

Lets you combine multiple fields into one, selecting the first value that is non-null.

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.

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

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)