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

D code

pivot value:KTHLARGESTUNIQUE(myRating, 3) group:postal_code limit:1

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

D s
snippetSyntax

D code

pivot value: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

...