View Navigation
Product Overview
Account Overview
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, bottom, or at whichever position in a table that you choose.


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.

Default settings

This step has the default settings to Keep the first 3 rows.

Custom settings

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!