Null if…

Description

Null If converts specific field values to null when they match a defined constant value. Use this step to clean or standardize data — for example, replacing placeholder values like "N/A", "UNKNOWN", or empty strings with null so that downstream steps and databases handle them consistently. You can apply the conversion to selected fields or all fields in the stream.

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.
Fields:
Name	Specify the name of the field that is to be checked/compared against a value
Value to turn to NULL	The value to be checked for replacement with null.