Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference UNIQUE
Functions and Expressions Reference Guide
215
UNIQUE
The UNIQUE function returns a series containing all the unique members of a
series.
Syntax
UNIQUE ( series-object-expression )
Meaning
UNIQUE ( series_to_evaluate )
Returns
This function returns a series-object.
Evaluates to a series containing all the unique members of series_to_evaluate.
Evaluates to NONE if series_to_evaluate evaluates to NONE.
Examples
UNIQUE ( PartNumber:Inventory:File ) returns the unique
PartNumbers in Inventory:File.
COUNT ( UNIQUE ( Customer:Order:File ) ) returns the number of
unique Customers in Order:File.
Uses
Use
UNIQUE when you need the unique members in a series.
Note UNIQUE can only be used in a map rule. It cannot be used in a component rule.
Related Functions
SORTDOWN, SORTUP