Dataflows
Limit rows
The category Limit rows in the dataflow step selection holds the step that restricts the number of rows in a table. To learn how to create a dataflow and add steps in general, see the first steps with dataflows.
In the [Select rows from] field (1) choose from where the rows are taken, and enter the wanted number under [Amount of rows] (2). Three modes are available:
- Top limits the table to the selected number of rows from the top.
- Range limits the table to the selected number of rows starting from a defined starting point.
- Last limits the table to the selected number of rows from the bottom.
Caution If you want to filter, for example, the three best selling items from a table of items and sales data, then you must apply the correct sorting BEFORE the row limit step so that the desired three rows are selected.
