Skip to main content

Aggregate

GROUP BY with aggregates, one per line: name = count(), total = sum(pop).

Syntax​

{ "id": "n1", "op": "aggregate", "name": "aggregate", "x": 0, "y": 0, "params": {} }

An edge into it ends at "targetPort": "in"; one out of it starts at "sourcePort": "out".

Inputs​

PortTypeTakes
intableone edge

Parameters​

ParameterKindDefaultChoices
groupBystring""
aggscode"n = count()"

Outputs​

PortType
outtable

Details​

  • Category: Tables
  • Operator: aggregate