Limit rows

The Limit rows step filters data by limiting the row amount. You can keep or remove a certain number of rows from the top or bottom at whichever position in a table that you choose.

Input/output

In our input data below, we have the list of product orders.

By using the Limit rows step, we can easily filter the number of rows to get the first 5 rows, as seen in our below output data that this step gives us.

Settings

Pick the dataset, then Choose from "Keep or Remove" dropdown the keep or remove options to specify if the condition will be applied to keep or remove table rows.

Choose from "Condition" dropdown first or last options to specify if the condition will be applied on first rows or last rows in a table.

Add the "Number of rows" to limit the rows.