Extracts the ranked 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 separate values. So, if your dataset contains three rows with column values 10 , 9 , and 9 , then KTHLARGEST returns 9 for k=2 and 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.

pivot value:KTHLARGEST(myRating, 2) group:postal_code limit:1

Output: Generates a two-column table containing the unique values in the postal_code column and the second highest value from the myRating column for that postal_code value. The limit parameter defines the maximum number of output columns.

pivot value:KTHLARGEST(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 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.

Required?Data TypeExample Value
YesString (column reference)myValues

k_integer

Integer representing the ranking of the value to extract from the source column.

NOTE: The value for k must be an integer between 1 and 1,000 inclusive.

Required?Data TypeExample Value
YesInteger (positive)4