Expect the values of a pair of columns to be either both filled or empty simultaneously.
expect_queried_column_pair_values_to_be_both_filled_or_null
This expectation level is BETA
Description
Expect the values of a pair of columns to be either both filled or empty simultaneously.
It checks if 2 columns are aligned - the values of each row need to either be both empty or filled.
The expectation will fail if there's at least one row where one column is filled and the other isn't.
Args:
- template_dict: dict with the following keys: column_a (str): first column name, to compare values against column_b
- column_b (str): second column name, to compare values against column_a
Returns:
None
Want to make your own Expectation or an improvement to this one?
We've put together some great how to guides (including videos) on how to create your own expectations in a flash!
You can see those resources here: Contributor Resources