Show Top or Bottom Rows¶
The Show Top or Bottom rows task allows for limiting of the data to just the first few rows or the last few rows. An additional sort can be specified with this task to determine the criterion for deciding the order of rows before applying the limit.
Table of Contents
Quick Start¶
Let us start with the following sample data:
Student |
Marks |
|---|---|
Alice |
95 |
Bob |
65 |
Chuck |
80 |
Diana |
50 |
Ellin |
89 |
Let us suppose that you want to fetch data about the top three students. Complete the following steps to achieve this:
Go to Transform > Label, Filter and Replace.
Select the Show Top/Bottom Rows function.
Enter the value 3 into the rows input.
Specify a sort: Sort by Marks in the descending order.
Click APPLY.
Your data should now look like this:
Student |
Marks |
|---|---|
Alice |
95 |
Ellin |
89 |
Chuck |
80 |
Supported Options¶
Following options are supported:
Top/Bottom: Whether the few rows are to be retained from Top or Bottom.
Limit: The number of rows to be retained.
Sort by: The sort to be applied to decide the order of rows. See Sort in tasks