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
- Open the Limit Rows dialog.
- Enter the maximum number of rows you want to display.
- 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
Get familiar with Workspaces in Gridscript.
Learn how to visualize your data with Gridscript charts.