To Create a Tuple Based Aggregator Operator

1. Drag a Tuple Based Aggregator operator from the Palette to the Design view.

2. Double-click the Tuple Based Aggregator operator.

   The property editor opens.

3. In the Start field, enter the record in which you want the operator calculations to begin.

4. In the Increment field, enter how often you want the analysis performed.

5. In the Expression box, enter the expression for the SQL SELECT statement that is used to specify the input attribute upon which the SELECT is performed. You can add, delete, or move attributes.

6. In the From box, define the input on which to perform the selection.

7. In the Where clause box, provide additional filtering on records.

   For example:

   WHERE price > 30.00 AND stockDate < '2006-01-01' ;

8. 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.

9. Click OK.