Coalesce

Description

The Coalesce transform lets you list multiple fields and returns the first non-null value.

Hop Engine

Supported

Spark

Maybe Supported

Flink

Maybe Supported

Dataflow

Maybe Supported

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.

Pick a list of fields to evaluate and specify a field name and type for the field output.

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

Option

Description

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)