Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

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.

D s
snippetBasic

KTHLARGEST
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextpivot value:
kthlargest(myRating, 2) group:postal_code limit:1

...

kthlargest(myRating, 2)

Output: Returns the second highest value from the myRating column for that postal_code value. The limit parameter defines the maximum number of output columns.

D s
snippetSyntax

KTHLARGEST
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextpivot value:
kthlargest(function_col_ref, k_integer) [ group:group_col_ref] [limit:limit_count]

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

...