Sorting - trillium_discovery - trillium_quality - 17.2

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:53:20.448228

You can change the order in which rows are displayed by changing the sort order. The Repository Manager lets you sort by the values in a column or by the data length of a column. The sort can be in ascending or descending order.

Note: After you sort a column, an arrow appears next to the column name. The arrow points up for ascending order and down for descending order.

To change the sort order of a list by value

  1. Right-click the label of the column on which you want to base the sort.

  2. Select Sort > Ascending or Sort > Descending.

Note: Click the column label to toggle between ascending and descending order.

To change the sort order of a list by attribute length

  1. Right-click the label of the column on which you want to base the sort.

  2. Select Sort by Length > Ascending or Sort by Length > Descending.

To base the sort on multiple columns

  1. Right-click any column label.

  2. Select Multi-Column Sort. The Multi-Column Sort window opens.

    Multi-Column Sort Window
  3. In the Sort Items By field, specify the following information for the primary sort key:

    • Column name

    • Direction (ascending or descending)

    • Type of sort: by default, Repository Manager sorts by value; if you want to sort by data length, click the Sort by Length check box.

    • Uniqueness: Check the Unique check box if you want the list to display only rows that contain unique values in this column.

  4. Repeat step 3 for each level of sort you want to apply.

  5. Click OK.