Top N rows
The Top N rows step allows you get the top N rows of your data based on value column to be ranked. The top can be performed by group if specified
Step parameters
Get top...
*(int): specify the number of top rows to retainSort column...
*(string): the ranking will be based on this column (so its values must be sortable)Sort order...
*["asc", "desc"]: whether the you want the above column to e sorted on ascending (asc
) or descending (desc
) orderGroup by...
(array): if you want to return a top by group, you can select one or several columns that will be used to constitute unique groups
Example
Input

Configuration
{
"limit": 5,
"rank_on": "salary",
"sort": "desc"
"group_by": []
}
Output

Last updated
Was this helpful?