Apama 10.11.3 | Building and Using Apama Dashboards | Dashboard Function Reference | Tabular Functions | Distinct Values
 
Distinct Values
Returns a table with a single column that lists all unique values from a specified column of a specified table.
Arguments
This function has the following arguments:
*Table: Table that contains the column whose unique values are to be returned.
*Column Name: Name of the column whose unique values are to be returned.
*Sort Values: Numeric value that controls whether the returned values are sorted. Set this to 1 in order to sort the values. Values are sorted in numerical order, if all values are numbers; otherwise they are sorted alphabetically.
*Sort Descending: Numeric value that controls whether the returned values are sorted in descending order, if Sort Values is set to 1. Set Sort Descending to 1 in order to sort the values in descending order. Set the argument to 0 (or leave it blank) in order to sort the values in ascending order.
*Use Column Name: Numeric value that controls the label of the returned column. Set this argument to 1 in order to use the original column name (the value of the Column Name argument). Set the argument to 0 (or leave it blank) in order to use the name Values. Use a generic name when you want a display that is independent of the value of Table, for example, because the value of Table uses a substitution that causes column names to change when the substitution changes.
This function returns a table.