This deprecated node aggregates the values within all records that possess the same key field values, enabling operations which are performed using multiple records.
Aggregates the input by the expression specified in GroupBy. (The input must be sorted by the same criteria.) Output the aggregated data. This uses the lastInGroup variable. This variable will be set if the current input record is the last one before moving on to the next aggregation group. This node provides access to all the features of aggregation; however, this access requires more setup effort on the part of the user. Unlike the Extended Aggregate node, the input to this node must be sorted by the GroupBy key before it enters the node. Contrarily, the Agg node is the only option in cases where data is output to multiple pins during aggregation.
Properties
Script
Specify the Script which controls the output.
A value is required for this property.
GroupBy
Specify the expression controlling how to aggregate.
A value is required for this property.
VerifyInputsSorted
Optionally specify whether this node will verify that the inputs are sorted according to the value of the GroupBy expression.
The default value is True.
VerifyInputsGrouped
Optionally specify whether this node will verify that the inputs are grouped according to the value of the GroupBy expression. This is more permissive then the requirement that the inputs are sorted, and may save a preceding sort, but at the slight cost of higher node memory utilization, since there is a slight memory utilization that is required to remember all values seen.
Please note that turning this property on does not turn off the VerifyInputSorted property; that needs to be disabled separately.
The default value is False.
Inputs and outputs
Inputs: in1.
Outputs: out1, multiple optional.