Shape · Summarize and reshape

Explode

Turns each item of a list column into its own row. For comma-separated text, use Split to Rows instead.

Also known as: Unnest, flatten

How it works

Pick the List column to explode. Each element becomes its own row in that column and every other column repeats. The column can be a native list or a text column holding a JSON array such as ["a", "b"]; the node checks the type at run time. A row whose list is null or empty is dropped, unlike Split to Rows, which keeps one row.

Inputs and outputs

Settings

{
  column: string
}

Example

A JSON reader gives an items column holding an array per order. Explode items to get one row per item, then pull the fields you need out of it.

More in Summarize and reshape

• Aggregate — Collapses rows into one row per group and works out values for each: sum, count, average, median, mode, percentiles, longest text and more, cash-flow values such as NPV or IRR, and for a geometry the dissolved shape, extent or centroid. With no group, you get one grand-total row.
• Group Aggregate — Works out a group total and writes it onto every row instead of collapsing them, as the value, a ratio or a percent. For example, each sale as a share of its region's total.
• Running Aggregations — Adds running totals that build up row by row: sum, average, median, min, max, count or standard deviation, optionally restarting per group. For example, year-to-date sales.
• Pivot — Turns the values of one column into new columns, such as one row per store with a column per month. The reverse of Unpivot.
• Unpivot — Turns chosen columns into rows of name and value pairs. For example, Jan, Feb and Mar columns become month and sales rows.
• Transpose — Swaps rows and columns, so every column becomes a row. Best for small, wide summary tables.
• Split to Rows — Turns a cell holding several delimited values into one row per value. For example, 'red;green;blue' becomes three rows.
• Split to Columns — Breaks one text column into several columns at a delimiter, such as 'London, UK' into city and country.