Gridscript

Limit

The Limit tool reduces your dataset to only the first N rows. This is especially useful when working with very large datasets, sampling for quick testing, or focusing on just the top results.

Key Features

  • Row count selection – Specify the maximum number of rows to keep.
  • Simple truncation – Rows beyond the specified limit are discarded from the grid view.
  • Non-destructive workflow – The underlying dataset remains intact in your project history, allowing you to re-apply or remove the limit as needed.
  • Efficient sampling – Ideal for quickly loading a preview of large tables without processing the entire dataset.

How to Use

  1. Open the Limit Rows dialog.
  2. Enter the maximum number of rows you want to display.
  3. Click Apply – the grid will be reduced to only the first N rows.

Example

Original dataset (5 rows)

ID | Name   | Score
-- | ------ | -----
1 | Alice | 90
2 | Bob | 85
3 | Carol | 92
4 | David | 78
5 | Eve | 88

Limit applied: Max Rows = 3

Resulting dataset

ID | Name   | Score
-- | ------ | -----
1 | Alice | 90
2 | Bob | 85
3 | Carol | 92

Workspaces

Get familiar with Workspaces in Gridscript.

Charts

Learn how to visualize your data with Gridscript charts.