Description
Description
Frictionless currently does not support validating multiple occurrences of values within a single field using built-in constraints. We have a use case where a field can contain multiple values from a predefined list, separated by semicolons (;). However, enforcing this pattern within the schema requires a workaround using regex patterns.
Use Case
We need to validate fields like OBSERVATION_CATEGORY_SDOH_CODE and OBSERVATION_CATEGORY_SDOH_TEXT, where values come from a fixed list but can appear multiple times in a single field, separated by semicolons.
✅ Example of valid values:
"food-insecurity"
"food-insecurity; housing-instability; employment-status"
"stress; social-connection"
Proposed Solution
Would it be possible to introduce native support for validating multiple occurrences of values within a single field? For instance, an enhancement to the "enum" constraint that allows defining separators (e.g., ";") or a dedicated "multiEnum" constraint?
If there are alternative approaches within Frictionless that we might have missed, please let us know. Any guidance would be greatly appreciated!
Thank you for your time and consideration.