Skip to content

Rank

Allows the user to determine the rank of a value in a group of values, output as a new column. For more information, read the following documentation:


Properties

Name = string

A human-readable name for the component.


Include Input Columns = boolean

Defines whether the component passes all input columns into the output.


Partition Data = dual listbox

Defines how the input data is partitioned to perform the rank calculation. The calculation is then performed on each partition.


Ordering Within Partitions = column editor

Order input columns within the partitioned data. You can drag to reorder. Choose the following value:

  • Ascending
  • Descending
  • Nulls First
  • Nulls Last

Functions = column editor

Select a window function:

  • Rank: Determines the rank of a value in a group of values.
  • Dense Rank: Determines the rank of a value in a group of values. The Dense Rank function differs from rank in one respect: If two or more rows tie, there is no gap in the sequence of ranked values.
  • Cumulative Distribution: Determines the cumulative distribution of a value within a window or partition.
  • Percent Rank: Calculates the percent rank of a given row.
  • Row Number: Determines the ordinal number of the current row within a group of rows, counting from 1.

Then, add the name of the output column that the window function will create.


Snowflake Databricks Amazon Redshift (preview)