If field value is null
Description
If Field Value Is Null replaces null values in the data stream with specified constant values to prevent downstream errors or unexpected behavior. Use this step when you need to ensure that no null values reach output steps, calculations, or external systems. It offers three modes: replacing nulls across all fields, replacing nulls only for specific data types (such as Number, String, or Date), or replacing nulls for individually selected fields with distinct replacement values for each.
Rows but only for specific fields by nameNote: Changing a numeric field type to an empty string field type can cause an error in the subsequent steps. The error appears only when the next step accesses that field.
Configurations
| Field Name | Description |
|---|---|
| Step name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Replace null for all fields: | |
| Replace by value | Specify the value for all null fields |
| Set empty string? | Enable checkbox to insert empty string otherwise it inserts null string. |
| Mask(Date) | Choose a Date Format from the dropdown list. |
| Select fields | Enable checkbox to select fields to be replaced for null values |
| Select value type | Enable checkbox to select value types for replacing null values |
| Value Types: | This is enabled when Select value type is enabled |
| Type | Choose the data type |
| Replace by value | Put the value for all null fields by data type |
| Conversion mask(Date) | Date Format |
| Set empty string? | Select Y to Set empty string or N to Set value to null |
| Fields: | This is enabled when Set empty string? above is enabled |
| Field | Select the fields whose null values have to be replaced. |
| Replace by value | Specify the value for all null fields by field |
| Conversion mask(Date) | Choose the date Format |
| Set empty string? | Select Y to Set empty string or N to Set value to null |