I want a column to only accept 'A, 'B', 'C' or 'D' as the correct values.

Big Mac

I want to restrict the values for a certain column. It should only accept either  'A, 'B', 'C' or 'D' as the correct values. If I see any other letters it should not pass the validation. What is the most efficient way to do it?

Josh Boxer

Hello

Automatic: 1) 'Explore' the data 2) 'Profile' the column (can right click the column header for a single column) 3) 'Suggest validation rules' for the profiled columns

4) Apply and it will create a workflow with a Validate step containing the chosen rules

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/create-a-single-customer-view-scv/discover-and-profile-data/#suggestvalidationrules

Manual:

1) add a Validate step to your workflow

2) create a new rule (Function)

3) use the 'Equals' function, select the column name as Input then enter 'A' as comparison, use the '+' to add the other 3 comparison values

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-functions/#default-functions

Equals - Checks the input value for equality with the comparison value(s), based solely on appearance (i.e. ignoring any differences in data type).