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?
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
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
Equals - Checks the input value for equality with the comparison value(s), based solely on appearance (i.e. ignoring any differences in data type).