Using the Relation Aggregator Operator Property Editor
See Also
Use the Relation Aggregator operator to take as input the output of a relation, treat that output as if it were a database table, and perform a SQL Select on that table. The Relation operator issues output in the form of a relation.
To create a Relation Aggregator operator:
- Drag a Relation Aggregator operator from the Palette to the Design view.
- Double-click the Relation Aggregator operator icon. The property editor opens with the default name of the Relation Aggregator operator and the output schema name populated. The property editor displays the schema of the data that is input to the Relation Aggregator operator.
- In the Select field, specify attributes you want to specify. Any attribute specified must appear in the group-by clause. Attributes you select as expression entries must be in the form of an attribute name, a literal, or an aggregate function supported by the database you use. Examples include:
- Sum
- Average
- Minimum
- Maximum
- COUNT
- In the Expression field, provide a SQL expression to further delimit your Select statement. To save some typing, you can drag input attribute field names from the Inputs area into the Expression field.
- Optionally specify a Where statement in the Where field to provide a search condition, which cannot have a subquery.
- In the group by field, specify a comma-separated list of attribute names, indicating how you want to group the attributes in the relation that the Relation Aggregator operator provides as output.
- Click OK.
- See Also
-
- Using the Relation Map Operator Property Editor
Legal Notices