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.
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.
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.
Limit rows
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.
Updated on: 20/09/2022
Thank you!