

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