Using the Distinct Operator Property Editor

See Also

The Distinct operator retains records input from a relation that are unique. If duplicate records exist, they will not be sent out from the Distinct operator. All attributes of records must match to be filtered with the Distinct operators.

You typically use the Distinct operator in conjunction with a relation output from another operator. The Distinct operator does not forward duplicate records from input to it. Typical operators whose input the Distinct operator uses include:

To create a Distinct operator:

  1. Drag a Distinct operator from the Palette to the Design view.
  2. Connect an input from an operator that has a relation result.
  3. Click the Distinct operator icon. The property editor opens with the name of the Distinct operator and the output schema name populated. The property editor displays the schema of the data that is input to the Distinct operator.
  4. Click Ok.
See Also
Using the Tuple Based Window Operator Property Editor
Using the Intersect Operator Property Editor
Using the Minus Operator Property Editor
Using the Union Operator Property Editor
Using the Union All Operator Property Editor
 

Legal Notices