Reference · Visual workspace
Check allowed values in Visual workspace
Quarantine rows whose value is not in an approved list.
When to use it
Status codes, countries and other controlled vocabularies.
How
Add step → Rules → Allowed values. List the values one per line and give a quarantine reason.
status must be one of 3 values (→ bad_status)
- Missing values are not in the list, so they are quarantined too; use Require a value first if they need a different reason.
Pitfalls
- Forgetting how missing values behave.
- Checking before normalizing case and spacing.
Lesson: Quarantine with reasons, in rule order
Practise it: Validate quantities and prices against ranges