This node assigns ranks to rows based on user-defined ordering criteria. The ranking is determined by selecting one or more columns, with the option to specify ascending or descending order. If multiple criteria are set, the table is first sorted by the primary criterion, and subsequent criteria are used only in the case of ties.
Additionally, ranking can be performed within groups by selecting one or more category columns, where each unique combination of category values defines a separate ranking group.