This deprecated node splits an input set into two outputs based upon whether records are found within a designated grouping.
Outputs every input record in the passing/failing groups.
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 to the output named "pass". If the group does not pass, then all records in the group are output to the output named "fail".Split 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.
GroupBy
Specify Script describing the expression on which to aggregate the data into groups.
A value is required for this property.
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.
Inputs and outputs
Inputs: in1.
Outputs: pass, fail.