← All features

Canvas nodes

Limit rows

Keep the first or last rows, with optional blank-row skipping.

How it works

Choose the number of rows to keep from the start or end of the current order. Sort first when the result should reflect a date or ranking.

Click Limit rows on Canvas to open its settings and output. The output contains the first three input rows.

Simple example

Set Rows on a Limit rows node to the number of records you want to inspect. The node passes through that many rows from the start of the input in its existing order.

Limit rows selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input

First 5 of 6 rows
Order IDStatusAmount
A101Shipped140
A102Pending85
A103Shipped220
A104Cancelled38
A105Shipped126

Node output

3 rows
Order IDStatusAmount
A101Shipped140
A102Pending85
A103Shipped220

Complex workflow

Sort orders by Order Date in ascending order, then enable Take from the end in Limit rows and set a row limit. Select Order Date in Skip blanks in to exclude undated records before taking the most recent rows.

Limit rows selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input

First 5 of 6 rows
Order IDOrder DateAmount
A101—140
A103—220
A1022026-10-1985
A1042026-11-0438
A1052026-11-06126

Node output

2 rows
Order IDOrder DateAmount
A1052026-11-06126
A1062026-11-0899