If field value is null
Description
If field value is null, is a step in the Utility Plugin for Process Studio Workflows. The step ‘If field value is null’ is used to replace nulls by a given value for,
- Rows with all fields
- Rows but only for specific field types (Number, String, Date etc.)
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
| No. | Field Name | Description |
|---|---|---|
| 1 | 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: | ||
| 1 | Replace by value | Specify the value for all null fields |
| 2 | Set empty string? | Enable checkbox to insert empty string otherwise it inserts null string. |
| 3 | Mask(Date) | Choose a Date Format from the dropdown list. |
| 4 | Select fields | Enable checkbox to select fields to be replaced for null values |
| 5 | Select value type | Enable checkbox to select value types for replacing null values |
| Value Types: | This is enabled when Select value type is enabled | |
| 1 | Type | Choose the data type |
| 2 | Replace by value | Put the value for all null fields by data type |
| 3 | Conversion mask(Date) | Date Format |
| 4 | 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 | |
| 1 | Field | Select the fields whose null values have to be replaced. |
| 2 | Replace by value | Specify the value for all null fields by field |
| 3 | Conversion mask(Date) | Choose the date Format |
| 4 | Set empty string? | Select Y to Set empty string or N to Set value to null |