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 retain

• Sort 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) order

• Group 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

Filter - Top N rows input

Configuration

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

Output

Filter - Top N rows output