Using the Tuple Based Aggregator Operator Property Editor
See Also
The Tuple Based Aggregator operator performs statistical analysis for a specified number of records (also called tuples) that you provide as a Size, and also for an Increment that indicates how often you want the operation performed.
For example, provided a stream of stock transactions, the Tuple Based Aggregator operator computes a new stream that holds the minimum, average, and maximum of the stock price of every 10 transactions, in which the Size is 10.
Statistics you can compute via SQL statements within the Property Editor of the Tuple Based Aggregator include:
- Sum
- Average
- Minimum
- Maximum
- COUNT
To create a Tuple Based Aggregator operator:
- Drag a Tuple Based Aggregator operator from the Palette to the Design view.
- Double-click the Tuple Based Aggregator operator icon. The property editor opens.
- In the Start field, enter the record in which you want the operator calculations to begin.
- In the Increment field, enter how often you want the analysis performed.
- In the Expression box enter the expression for the SQL Select statement which is used to specify the input attribute upon which the Select is performed. You can add, delete, or move Attributes.
- In the From box, define the input on which to perform the selection.
- In the Where clause box, provide additional filtering on records, for example, WHERE price > 30.00 AND stockDate < '2006-01-01' ;
- In the Group by box, group a result into subsets that have matching values for one or more columns of the database by specifying a comma separated list of qualified attribute names.
- Click OK.
- See Also
-
- Using the Time Based Aggregator Operator Property Editor
Legal Notices