Hitachi Vantara Pentaho Community Wiki
Child pages
  • If field value is null
Skip to end of metadata
Go to start of metadata


The step "If field value is null" is able to replace 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

Note: Changing a numeric field type to an empty string field type can cause an error in the subsequent steps. The error will not appear until the next step accesses that field.

Metadata Injection Support (7.x and later)

All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.

  • No labels


  1. user-fb20e

    How is the "Mask (Date)" used?  I was hoping it would append the date to the end of the value, but this doesn't work.

  2. Please use the forum to ask questions.