This deprecated node filters record groups based on a specified expression. Outputs every input record in the groups which pass.
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 all records in the group are output. Filter By Group only works in cases where the aggregation expression is a single field value.
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 an expression which evaluates to true/false, describing the condition that at least the specified number of records in each group must pass.
A value is required for this property.
GroupBy
Specify Script describing the expression on which to aggregate the data into groups.
A value is required for this property.
Inputs and outputs
Inputs: in1, multiple optional.
Outputs: out1, multiple optional.