Set default to always ignore NULLS

Jasper

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.

Josh Boxer

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

Jasper

Thank you that worked, at least for Existing Functions.