Expect the values for each record to be unique across the columns listed.
expect_select_column_values_to_be_unique_within_record
This expectation level is PRODUCTION
Contributors:
Tags:
Metrics:
Description
Expect the values for each record to be unique across the columns listed.
Note that records can be duplicated.
expect_select_column_values_to_be_unique_within_record is a Multicolumn Map Expectation.
For example:
A B C
1 1 2 Fail
1 2 3 Pass
8 2 7 Pass
1 2 3 Pass
4 4 4 Fail
Args:
- column_list (tuple or list): The column names to evaluate
Keyword Args:
- ignore_row_if (str): "all_values_are_missing", "any_value_is_missing", "never"
Other Parameters:
- result_format (str or None): Which output mode to use: BOOLEAN_ONLY, BASIC, COMPLETE, or SUMMARY. For more detail, see result_format.
- include_config (boolean): If True, then include the expectation config as part of the result object.
- catch_exceptions (boolean or None): If True, then catch exceptions and include them as part of the result object. For more detail, see catch_exceptions.
- meta (dict or None): A JSON-serializable dictionary (nesting allowed) that will be included in the output without modification. For more detail, see meta.
Returns:
Exact fields vary depending on the values passed to result_format, include_config, catch_exceptions, and meta.
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