Limit Rows

Cut a long table down to a set number of rows.

What it does

Limit Rows keeps a set number of rows and removes the rest. You type the number. There is no column to pick. You can sort the table first. Then the rows you keep are the largest or the smallest by that column.

Keep the first rows

  1. Open the Pipeline panel.
  2. Type limit in the Search transforms box.
  3. Select Limit Rows in the results list.
  4. Type a number in Number of rows. For example, type 100.
  5. Click Apply.

The grid now shows 100 rows. The step appears in your pipeline. You can edit it or delete it later.

Sort before you cut

Without a sort, Limit Rows keeps the rows in their current order. To change that, use the sort fields:

  1. Open Sort by (optional). It reads Choose column... until you pick one.
  2. Pick a column. Each entry shows the column name and its type.
  3. A Sort direction dropdown appears. It is already set to ASC.
  4. Keep ASC for smallest first. Select DESC for largest first.
  5. Click Apply.

Example: you have a table of sales orders. Sort by order_total with DESC. Set Number of rows to 100. You keep your 100 biggest orders.

Tips

  • The Sort direction dropdown stays hidden until you pick a sort column.
  • The row count must be above zero. Zero or a blank box shows an error.
  • Limit Rows never sorts on its own. Pick a sort column when order matters.
  • To keep the last rows instead of the first, use Top / Bottom Rows.

For SQL users

The step runs one query. A limit of 100 with a DESC sort runs as:

SELECT * FROM data ORDER BY "order_total" DESC LIMIT 100
Try Limit Rows with sample data →

Related Operations