NULL and NOT NULL Filters¶
Use the following examples to apply NULL and NOT NULL filtering:
-- Validate data only where certain fields are populated
invalid_count(phone_number) = 0
-- Filter:
customer_tier IS NOT NULL
-- Check consistency in records with missing optional fields
missing_count(secondary_email) <= 10
-- Filter:
primary_email IS NULL