Shape · Summarize and reshape

Split to Columns

Breaks one text column into several columns at a delimiter, such as 'London, UK' into city and country.

Also known as: Text to columns

How it works

Pick the Column to split and the Delimiter, , by default. Max columns caps how many pieces become columns; leave it blank and the node scans the data for the longest value and makes that many. Output names is a comma-separated list; a blank position falls back to <column>_n. When Max columns is blank, a name that clashes with an existing column gets a numeric suffix; with a fixed count, pick names the input does not already have. A value with fewer pieces leaves the remaining columns null. Drop original column and Trim whitespace around tokens are both on by default. A set Max columns lets the node run on the drone; the auto count needs the desktop.

Inputs and outputs

Settings

{
  column
  delimiter
  maxSplits?
  outputNames?
  dropOriginal
  trimWhitespace
}

Example

A location column holds London, UK. Split on , with Max columns 2 and Output names city, country.

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.
• Explode — Turns each item of a list column into its own row. For comma-separated text, use Split to Rows instead.