This deprecated node combines an Agg node and a Transform node to allow you to specify which of the aggregate records get written to the output data file.
The node performs the PredicateExpr test on every record. For each group, the node tracks how many records passed the test. The group as a whole passes the filter based on the value of GroupFilter:
- Any - Any records pass
- All - All records pass
- None - No records pass
- <int> - A number of records pass
- <int>+ - At least the specified number of records pass
If the group passes, then the last record in the group is output. The format of this record is controlled through the OutputExprs property.
Properties
GroupFilter
Specify how many records in the group must pass the test. Choose from:
- Any
- All
- None
- 1
- 2
Alternatively, you can type in a number of your own.
PredicateExpr
Specify a test expression which resolves into a true/false condition. The test is applied to every record.
A value is required for this property.
GroupBy
Specify an expression controlling how to aggregate.
A value is required for this property.
OutputExprs
Optionally specify expressions used to control output.
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.
Note, 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.