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

Supported

Flink

Supported

Dataflow

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.