I want a column to only accept 'A, 'B', 'C' or 'D' as the correct values.
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?
0
Answers
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).