Agg Filter - 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 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.

CAUTION:
This node has been deprecated and will not be supported in a future release. As an alternative, the Aggregate and Transform nodes 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 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.