Shape · Rows

Top / Bottom N

Keeps the N rows with the largest or smallest values in one column, such as the 10 best-selling products. You choose what happens to ties at the cut-off.

Also known as: Leaderboard, nlargest

How it works

Column is the column to rank by and Number of rows the N to keep, 10 by default. Mode keeps the Largest or Smallest values. When values tie decides what happens at the cut-off: First and Last keep exactly N rows, choosing among tied rows by their input order; All ties keeps every row whose value is among the N largest (or smallest) distinct values, so tied rows never push others out and it can return more than N rows. Rows with a NULL in the column are left out. The node does not run until a column is picked.

Inputs and outputs

Settings

{
  column: string
  n: number
  mode: "largest"|"smallest"
  keep: "first"|"last"|"all"
}

Example

The three best-selling products, keeping every product that ties for third place: Column units, Number of rows 3, Mode Largest, When values tie All ties.

More in Rows

• Filter — Keeps only the rows that meet your conditions, combined with AND or OR. For example, keep orders where the amount is over 100.
• Switch — Sends each row down one of several outputs: it goes to the first case whose condition is true, and rows that match none go to Default.
• Sort — Puts rows in order by one or more columns, ascending or descending, with blanks first or last.
• Row Limit — Keeps or drops the first or last N rows, in their current order. For example, skip three header lines or take 100 rows for a quick check.
• Distinct — Keeps one row per unique combination of key columns. You choose whether the first or last copy survives; with no keys it drops exact duplicate rows.
• Random Sample — Picks a random set of rows, either a fixed number or a share such as 10%. You can sample with replacement, or stratify by a column so each group keeps its share. Set a seed to get the same rows every time.
• Random Split — Divides rows into named groups by percentage, each on its own output, such as 80/20 train and test. Repeatable, and can keep each group's share of a column.
• Add Row Number — Numbers the rows 1, 2, 3… in a new column. You can sort first and restart the count in each group.
• Rank — Ranks rows by one or more columns, optionally within groups, so the top seller per region gets 1. You choose how ties are ranked; percentile rank is available too, and Tile splits the rows into N equal-sized buckets.
• Densify — Adds the rows that are missing so every key combination appears, taken from the data or from a reference table you wire in, and fills the gaps with values you choose. For example, every product for every month, with 0 sales where none were recorded.
• Generate Rows — Repeats each row once per value of a range, such as 1 to a count column or a start date to an end date, and adds the generated value as a column. For a sequence with no input, use Generate Series.