What node can you use for sorting results, for example, to show the top 100?

The Rank node is specifically designed to sort data and retrieve specific rows based on their ranking. It allows users to define criteria for ranking, such as ordering rows by a specific numerical value and limiting the result set to only the top N entries. For example, if you wanted to display the top 100 entries from a dataset, the Rank node can efficiently achieve this by first sorting the data based on the defined criteria and then applying a filter to return only the top 100 results.

In contrast, the Union node is used to combine results from multiple sources into a single dataset without sorting or ranking. The Projection node allows users to select specific columns from a dataset but does not sort the data. The Aggregation node summarizes data based on specific dimensions but does not handle the ordering of results in the context of ranking. Therefore, for tasks specifically aimed at sorting and retrieving top entries, the Rank node is the optimal choice.