Set default to always ignore NULLS
Hi,
I am doing sever DQ checks on a single field within a validation step. On each of these checks I want to skip the check if the field is NULL (i.e. so only performing the check on the populated cells).
To ignore, in each function I am doing the normal test (e.g. DoB is Date), and also a IF THEN ELSE, to ignore where empty. I have to keep repeating this for each separate rule which is a lot of extra clicks. Is there a simple way to tell ADS to ignore the nulls for every test in the validation group? .
I do not want to filter out as I have another group in the same validation step that I test for completeness.
Thanks.
0
Comments
Hi Jasper
There is checkbox that will do this for you:
You can also use the Function script editor to reduce the number of clicks when editing Functions/rules
https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/improve-data-quality/validate-and-enrich-data/#validate-step_validationrulescripteditor
Thank you that worked, at least for Existing Functions.