If Null transform Icon If Null

Description

The If Null transform replaces nulls by a given value either by:

  1. Processing the complete row with all fields

  2. Processing the complete row but only for specific field types (Number, String, Date etc.)

  3. Processing the complete row but only for specific fields by name

Supported Engines

Hop Engine

Supported

Spark

Maybe Supported

Flink

Maybe Supported

Dataflow

Maybe Supported

Metadata Injection Support

All fields of this transform support metadata injection. You can use this transform with Metadata Injection to pass metadata to your pipeline at runtime.