Developing Apama Applications > Dashboard Function Reference > Tabular Functions > Count Unique Values
Count Unique Values
Returns a table that lists unique values and their counts from the specified table column.
Arguments
The function has the following arguments:
*Table Column: Data table column whose values are to be counted.
*Value List: Table column that specifies values for which a count is to be performed. If you do not supply this argument, counts are returned only for values present in Table Column. Use this argument to include rows in the returned table for values that are not always present in Table Column. If you specify this argument, the returned table includes a row for each specified value, even if the count for some values is 0.
*Restrict to Value List: Numerical value (0 or 1) that determines whether a count is performed only for values in Value List. If Restrict to Value List is set to 0, all unique values from the Table Column are included in the returned table. If Restrict to Value List is set to 1 and Value List is specified, only rows from the Value List are included.
*Use Column Names: Numerical value (0 or 1) that determines whether original column names are retained in the returned table. If Use Column Names is set to 1, then original column names are retained. If set to 0, columns are given generic names (for example, Subtotal1 and Total1). Generic column names are useful when the data attachment for the Table argument uses a substitution that causes the column names to change when the substitution changes.
This function returns a table.
Copyright © Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its Subsidiaries and or/its Affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.