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:
- Attribute-Based Window operator
- Partitioned Window operator
- Time Based Window operator
- Tuple-Based Window operator
- Relation Map operator
- Relation Aggregator operator
To create a Distinct operator:
- Drag a Distinct operator from the Palette to the Design view.
- As needed, connect the input of the new Distinct component to an operator that has Relation output.
- Double-click the Distinct component. The property editor opens. Notice that the component has inherited the schema of its input relation.
- As needed, configure the following property: Name.
- (Optional) Click the Documentation tab and supply notes on this component.
- Click OK.
- See Also
-
- 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