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

GroupBy

Grouper Node

Type

transform

Fields

NameTitleDescription
groupingColsGrouping ColumnsGrouping Columns
aggregateColsAggregate ColumnsAggregate Columns
aggregateOperationsAggregate Operation to UseAggregate Operation
havingClauseHaving Clausehaving condition after group by function
whereClauseWhere Clausewhere condition before group by function

Examples

Input

nameageheight
Alice580
Alice580
Alice1080
James550
James1060
James780

Parameters1

NameValue
Grouping Columnsname
Having Clause
Where Clause
IdAggregate ColumnsAggregate Operation to Use
1agemax
2heightmin
3namecount

Output1

namemax_agemin_heightcount_name
James10503
Alice10803

Parameters2

NameValue
Grouping Columnsname
Having Clause
Where Clause(age = 5 or age = 7) and height != 50
IdAggregate ColumnsAggregate Operation to Use
1agemax
2heightmin
3namecount

Output2

namemax_agemin_heightcount_name
James7801
Alice5802

Parameters3

NameValue
Grouping Columnsname
Having Clausemin_height > 60
Where Clause
IdAggregate ColumnsAggregate Operation to Use
1agemax
2heightmin
3namecount

Output3

namemax_agemin_heightcount_name
Alice10803