Ingest: Support multiple values per cell
A single dataset value may contain multiple observations, separated with e.g. ;
(MCPD array syntax).
The user should be able to specify if the data in this column uses a separator (defaults to not separated, but using ;
as the default char).
The incoming example
data is then split by ;
and registered as individual terms -- if not already defined as a term.
Filters
CODED
filter uses example
data and needs to continue displaying the distinct options -- just with the updated title sourced from individual terms mentioned.
1&4&11
value will be rendered as 1
4
11
-- White
Blue
11
(if 11
has no definition).
SCALE
, NUMERIC
and DATE
filters cannot support this and will allow for filtering the Preview with wrong data.