How to remove a row if a field has null value?
(Alternative to Data Validator, it’s not working)
You may use filter row. It has a “Is Null” validation
1 Like
In Data Validator, if you deselect the Allow Null Value option and configure Error Handling, the behavior is as follows:
-
Null records will be routed to the Error Handling hop.
-
Non-null records will pass to the normal output for further processing.
If error handling is not working as expected, it is possible that the Error Handling hop is not properly connected from the Data Validator step. Ensure the error output is correctly mapped.
Alternatively, you can use a Filter Row step to explicitly check for null values:
-
Condition:
Field IS NULL→ Route to error flow -
Condition:
Field IS NOT NULL→ Route to main processing
