Filter By Group - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

This deprecated node filters record groups based on a specified expression. Outputs every input record in the groups which pass.

CAUTION:
This node has been deprecated and will not be supported in a future release. As an alternative, the Transform node can be used to provide similar functionality.

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.