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']"