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

Limit rows


In our input data below, we have 50 rows of data.

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


This step has the default settings to Keep the first 3 rows.
You may select other options in the Keep dropdown and switch this to Remove.

You may also select other options in the first dropdown by switching this to the last or a random set of rows.

Lastly, you can enter in any number to limit the rows down to by clicking on the 3 and typing in your desired amount. Save your settings by clicking Show Updated Results and you're all set to go!

Was this article helpful?
Thank you!