PIVOT_CATEGORIES
Action
¶
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
Example
"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 |
To:
ID | Field | NewField |
---|---|---|
2 | Term2 | Cat1 |
3 | Term3 | Cat1 |
4 | Term4 | Cat1 |
6 | Term6 | Cat2 |
7 | Term7 | Cat2 |
8 | Term8 | Cat2 |