Operator Name

Description

Example

Filter

Defines selection criteria for displaying data.

You can filter documents by Creation Date so that only documents created on the specified date are displayed.

Sort

Sorts data up/down in a specified field.

You may want to alphabetically sort a list of documents by Document Name, with a secondary sort according to Document Date, newest to oldest.

Sigma

Aggregates the values of all the records of a specified field into a single record.

For material orders, you may create an output record that totals the values of all the orders.

Upper

Displays the specified number of records with the highest values.

Reviewing top performance scores of sales managers, you may choose to retain the top three sales records.

Lower

Displays the specified number of records with the lowest values

For archiving purposes, you may choose to output the oldest 20 documents, by Document Date.

Distinct

Omits records containing duplicate data in the selected fields. Note that the fewer fields checked as distinct, the fewer records returned.

A data service returns the following fields: Bank Country, Bank Key and Bank Name. If only Bank Country is checked, the first appearance of a value – such as France – in the combination of Bank Country – Bank Key – Bank Name is returned. Any subsequent combination containing France will not be returned. If, on the other hand, all three fields are checked, each combination becomes distinct, so that the potential list of results is greater.

Union

Merges into a new dataset the data of two datasets, and removes duplicates.

Data returned from a number of data services may include a field, called Sales Region, each containing different data. Union combines all of the results of these two fields into a single field (table column).

Intersect

Derives a new dataset from data that exists in both of two datasets.

Data returned from one data service gives the Capital Cities of countries around the world, while another gives Capital Cities, but only those in Europe. The data returned through the Intersect operator includes only those European capital cities returned from both data services.

Subtract

Derives a new dataset from multiple datasets by including data that is only in the first dataset but not in any of the other datasets.

The dataset from which the subtraction is made (the "first" dataset) is that which is transferred to the topmost input port of the operator.

In contrast to the example of Intersect (previous row), the resulting table for Subtract displays only those Capital Cities of Europe that are not returned from the first data service.

Group by

Groups a dataset into groups according to the selected operation – such as Min or Count – defined for one or more fields (columns).

For a sales figures table, the Sales Orders field (column) may be grouped by Max, while the Quantity field may be grouped by Average.

Combine

Combines two datasets into a new dataset, channeled into an input form.

The Bank Details data service contains two out ports: Bank Address and Bank Details. Combine can channel the results into a single form, containing fields for all the returned fields.

Switch

[Flash only] Receives input from multiple sources (such as a data service and a form view) and pass the received data as input to a single model element. You need to map the relevant fields of each input line to the port of the switch operator.

You have an Employee Details table that receives fields about the employee’s employment history from an Employment data service, and telephone numbers from a dedicated Phone Information Web service. You output this information onto a single form.