Extracts the ranked unique value from the values in a column, where `k=1` returns the maximum value. The value for `k` must be between 1 and 1000, inclusive.

For purposes of this calculation, two instances of the same value are treated as the same value of `k`. So, if your dataset contains four rows with column values `10` , `9` , `9` , and `8`, then `KTHLARGEST` returns `9` for `k=2` and `8` for `k=3`.

When used in a `pivot` transform, the function is computed for each instance of the value specified in the `group` parameter. See Pivot Transform.

Input column can be of Integer or Decimal type. Non-numeric data in the column is ignored. If a row contains a missing or null value, it is not factored into the calculation.

 kthlargestunique(myRating, 3)

Output: Returns the third highest unique value from the `myRating` column.

 kthlargestunique(function_col_ref, k_integer) [ group:group_col_ref] [limit:limit_count]

ArgumentRequired?Data TypeDescription
function_col_refYstringName of column to which to apply the function
k_integerYinteger (positive)The ranking of the unique value to extract from the source column

For more information on the `group` and `limit` parameters, see Pivot Transform.

function_col_ref

Name of the column the values of which you want to calculate the mean. Column must contain Integer or Decimal values.

• Literal values are not supported as inputs.
• Multiple columns and wildcards are not supported.

Required?Data TypeExample Value
YesString (column reference)`myValues`

k_integer

Integer representing the ranking of the unique value to extract from the source column. Duplicate values are treated as a single value for purposes of this function's calculation.

 NOTE: The value for `k` must be an integer between 1 and 1,000 inclusive.
• `k=1` represents the maximum value in the column.
• If k is greater than or equal to the number of values in the column, the minimum value is returned.
• Missing and null values are not factored into the ranking of `k`.

Required?Data TypeExample Value
YesInteger (positive)`4`