Skip to main content

Varicent ELT Help Center

Rank

Abstract

Compare values in your data by ranking rows according to the rules that you specify.

Rank rows according to rules you specify. You can rank in ascending or descending order.

Tip

Group by is an optional configuration setting.

How the tool handles ties is based on the ranking rules:

  • Rank. When there are ties, the next item in the sequence starts at the number of items before it. This means there will be a gap in the rankings.

  • Dense. When there are ties, there are no gaps for the next item in sequence.

When to use this tool

Use when you want to compare values.