Skip to main content
info
This documentation is for version v2.3 of the product.
For the latest version(v2.7) documentation click here
Version: v2.3 print this page

PivotBy

Pivot Node

Type

transform

Fields

NameTitleDescription
groupingColsGrouping ColumnsGrouping Columns
pivotColsPivot ColumnsPivoting Columns
aggregateColsAggregate ColumnsAggregate Columns
aggregateOperationsAggregate Operation to UseAggregate Operation

Examples

Input

nameageheight
Alice580
Alice580
Alice1080
James550
James1060
James780

Parameters

NameValue
Grouping Columnsname
Pivot Columnsage
IdAggregate ColumnsAggregate Operation to Use
1agemax
2heightmin

Output

name5710
James508060
Alice8050