One row per...

Fans a list field out into one row per element.

For each row, the named list field becomes one row per element. An element that is itself a record spreads into the row; any other element lands under the field's own name. Rows where the field is missing or not a list pass through untouched.

Properties

• Field: the list field to fan out. Required.
• Keep others: carry the source row's other fields onto every new row. On by default.

See also: Aggregate