Sort on one or more columns

Sorting the contents of a table helps you visualize your content and find the data you want. You can sort on one or more columns.

Important 

In Collibra 2024.05, we launched a new user interface (UI) for Collibra Data Intelligence Platform! You can learn more about this latest UI in the UI overview.

Use the following options to see the documentation in the latest UI or in the previous, classic UI:

Note 
  • The availability of multi-column sorting and the maximum number of columns on which you can simultaneously sort depends on the Multi-column sort settings in Collibra Console.
  • Multi-column sorting is not available in tile display mode. You can, however, sort on more than one column while in table display mode and then switch to tile display mode. The sort results will be accurately applied to the tiles. For more information, go to Sort a set of tiles.
  • (up arrow) in a column name indicates that the current sort order is ascending and (down arrow) indicates that the current sort order is descending.

Steps

Single-column sorting

  1. Open a view in table display mode.
    The table is automatically sorted in ascending order of the Name column, as indicated by (up arrow).
    Tip To sort the table in descending order of the Name column, click the column name.
  2. Click the name of the column on which you want to sort.
    The up arrow appears next to the column name and the table is sorted in ascending order of the column.
    Tip To sort the table in descending order of the column, click the column name again.

Multi-column sorting

  1. Open a view in table display mode.
    The table is automatically sorted in ascending order of the Name column, as indicated by (up arrow).
    Tip To sort the table in descending order of the Name column, click the column name.
  2. Click the name of any other column on which you want to sort.
    The table is sorted in ascending order of the column, and the up arrow followed by 2 appears next to the column name, indicating that the column has the second priority in sorting. Additionally, 1 is shown on the Name column, indicating that the Name column has the first priority in sorting.The table is sorted in ascending order of the column, and 2 followed by the up arrow appears next to the column name, indicating that the column has the second priority in sorting. Additionally, 1 is shown on the Name column, indicating that the Name column has the first priority in sorting.
    Tip 
    • To sort the table in descending order of the column, click the column name again.
    • To remove the sorting from any column, keep clicking the column name until the up or down arrow disappears.
    • By default, at least one of the columns is always sorted and you cannot remove the sorting from it.
  3. To sort the data on more columns, perform the previous step.
    Tip The data in the table is first sorted by the column having the first priority (indicated by the number 1 on the column name). Within that sort result, the data is further sorted by the column having the second priority (indicated by the number 2 on the column name), and so on.