1. Component library
  2. Transform
  3. Filter
  4. Null check

Null check

Filter rows that contain null values.

Filter Query optimizer Concurrent Distributed execution possible Alias: Not null

Filter outcomes

  • NULL

  • NOT_NULL

Configured properties

  • Columns

    Select columns that should NOT have null values

    List of InputColumn<Object> Required

  • Consider empty string as null

    Consider empty strings ("") as null also?

    boolean Required

  • Evaluation mode

    Choice: When all fields are NULL, the record is considered NULL When any field is NULL, the record is considered NULL Required