Skip to content



Bases: BaseCategoryAction

Convert row-level categories into field categorisations.

Script template

"PIVOT_CATEGORIES > 'destination_field' < 'source_field'::[int, int, int, etc.]"

Where int contains the rows that define the categories, and field are the fields to include. Makes several assumptions:

  • Rows may contain more than one category
  • All terms in indexed rows in the same field are related
  • Categories are assigned downwards to all rows between indices
  • The last indexed category is assigned to all rows to the end of the table


"PIVOT_CATEGORIES > 'NewField' < 'Field'::[1, 5]"

Will transform:

ID Field
1 Cat1
2 Term2
3 Term3
4 Term4
5 Cat2
6 Term6
7 Term7
8 Term8


ID Field NewField
2 Term2 Cat1
3 Term3 Cat1
4 Term4 Cat1
6 Term6 Cat2
7 Term7 Cat2
8 Term8 Cat2