Articles on: Transforms

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.

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

Was this article helpful?

Share your feedback

Cancel

Thank you!