The step "If field value is null" is able to replace nulls by a given value either by
- Processing the complete row with all fields
- Processing the complete row but only for specific field types (Number, String, Date etc.)
- 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.
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.