Unique

Unique Function

Returns a list of unique values for the given columns. You can specify the columns by name, as in [Customer.LastName] to use the LastName column of the Cutomer table. Or you can create columns using new data that you specify, as in Array (1,2,3) to create a column with three valuews (1,2,3).

Syntax

Unique (vector Column1, Column2,...)

Arguments

Argument	Description
vector Column1, Column2,...	A list (vector) of the columns to be searched for unique values

Examples:

Unique([FusionTestTable.VarcharColumn])

Returns a unique value in a specified column and returns the count.