Hitachi Vantara Pentaho Community Wiki
Access Keys:
Skip to content (Access Key - 0)

Description

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.


  1. Nov 07, 2012

    Jan Bennett says:

    How is the "Mask (Date)" used?  I was hoping it would append the date to th...

    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. Nov 08, 2012

    Jens Bleuel says:

    Please use the forum to ask questions.

    Please use the forum to ask questions.

This documentation is maintained by the Pentaho community, and members are encouraged to create new pages in the appropriate spaces, or edit existing pages that need to be corrected or updated.

Please do not leave comments on Wiki pages asking for help. They will be deleted. Use the forums instead.

Adaptavist Theme Builder (4.2.0) Powered by Atlassian Confluence 3.3.3, the Enterprise Wiki