Skip to content

PIVOT_LONGER

Action

Bases: BaseSchemaAction

Pivot a list of columns to create a new long table format.

Script template

"PIVOT_LONGER > ['name_field', 'value_field'] < ['source_field', 'source_field', etc.]"

Will assign to the destination fields as:

  • name_field: containing the original source field names, as appropriate,
  • value_field: containing the original values corresponding to the original source fields.

Example

"PIVOT_LONGER > ['year', 'values'] < ['1990', '1991', '1992', '1993']"