Flatten Delimited

FlattenDelimited transform flattens (or normalizes) a field or a set of fields that contain delimited values.

Parameters

field Required
Field(s) to split and flatten
as
The output field name(s) for the flattened field.
Default: the input fields.
separator Required
Separator(s) used on the field(s)

Example

Given the following data:

patient tissue value
A Ova,Asc 4,2
B Adn,Asc,Ute 6,3,4

... and configuration:

{
  "type": "flattenDelimited",
  "field": ["tissue", "value"],
  "separator": [",", ","]
}

TODO: Rename separator to delimiter

Flattened data is produced:

patient tissue value
A Ova 4
A Asc 2
B Adn 6
B Asc 3
B Ute 4