Work with tables

You can edit cells, wrap text, sort columns, navigate between table pages, and apply column filters in a table.

Important 

In Collibra 2024.05, we launched a new user interface (UI) for Collibra 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:

Edit cells

You can edit certain cells within a table.

Note 
  • This action can't be undone.
  • The Technical data type of a column can't be edited from a view. You can edit the value only from an asset page, if the Technical Data Type attribute has been added separately to the asset type layout.

The following levels of granularity are provided for editing:

  • Single cell within a column
  • Specific cells within a column
  • All visible cells within a column

Steps

  1. Open a view in table display mode.
    Tip To edit multiple cells within a column, select the checkboxes in the respective rows. To edit all the visible cells within a column, you don't need to select any checkboxes.
  2. Double-click one of the cells. Alternatively, you can double-click in one of the cells.
    Tip If the cell contains an attribute other than True/False, a dialog box appears for you to specify a value.
  3. Specify the value you want.
  4. Do one of the following:
    If you want to changeDo
    The current row only Click .
    The selected rows or all visible rows

    Select the Apply to all selected rows or Apply to all visible rows checkbox, and then click .

  5. Select the Apply to all selected rows or Apply to all visible rows checkbox.
    Tip If you don't want to apply your change, click X or Cancel.
  6. Click or Save.
    The new value is shown in the cells.

Wrap text

Wrapping the text makes the text in the cells of a table span multiple lines, allowing you to read the complete text within the cells, without having to adjust the column width.

Wrap text in one cell

Wrapping the text in one cell of a table automatically wraps the text in all the cells within the same row of the table.

Steps

  1. Open a view in table display mode.
  2. Hover your pointer over the cell, and then click .

    Complete text is shown in all the cells within the same row of the table.

    Note This text wrapping is lost when you refresh the page.

Wrap text in all cells

Prerequisites

Ensure that hierarchy is disabled.

Steps

  1. Open a view in table display mode.
  2. On the content toolbar, click Wrap Text.

    If the table previously showed more than 20 rows, only 20 rows are now shown per page.

    Complete text is shown in all the cells of the table.
  3. If you want to save this text wrapping, on the view toolbar, click Save.

Tip You can undo the text wrapping by changing the number of rows shown per page.

Steps

  1. Open a view in table display mode.
  2. Click .

Sort 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.

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 Work with 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.

If a table contains more rows than are currently shown, the rows are split into pages and the page numbers are shown in the lower-leftright corner of the table. You can navigate between these pages.

Image of a table showing options to navigate between its pages

Image of a table showing options to navigate between its pages

Steps

  1. Open a view in table display mode.
  2. To navigate to the next page, click .
  3. To navigate to the previous page, click .
  4. Do one of the following.
    To navigate toClick
    The previous page
    The next page
    The first page

    The first page number, for example, 1-10

    One of the 2 previous or next pagesThe required page number
    The last page

    The last page number, for example, 100-110

Apply column filters

You can use a column filter to see only those rows that contain a particular value in a column.

Steps

  1. Open a table.
  2. Hover your pointer over the heading of the column you want to filter, and then click .
    A filter box appears.
  3. Enter the column value based on which you want to filter the rows.
    Only the rows containing the entered value in the column are shown.

Tip If you want to clear the column filter, hover your pointer over the column heading, click , and then click .