Set default to always ignore NULLS
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.