Sorting Data and Editing Tables

You can sort the data in Insight for Research.

This task shows you how to:

Show or Hide Columns

You can adjust the visibility of the table columns.

  1. In the Primary Data table, click Configure columns.
  2. Under Configure Columns, select the columns to show or hide.

    You can also search for columns. If your search results in a list of multiple columns, you can choose to show or hide all of the listed columns.

    Tip: To hide columns, you can also drag the column header away from the table. You cannot use this method for columns that contain chemistry.

Sort Columns

You can sort a column of data in a table in ascending or descending order.

Do one of the following:
  • Click the column header name.
  • Click at the right of the column header, click Sorting, and then select Ascending, Descending, or Default.

You can have multiple columns sorted.

Resize Columns

You can change the size of the Primary Data columns.

Drag the edge of the column to change the column width. You can also double-click the right edge of the column header to automatically resize the column.

Reorder Columns

You can rearrange the order of the Primary Data columns.

Using the column header, drag the column to a new position.

If the table contains hierarchical properties, when you move a column, all columns belonging to the same parent level move together. You cannot move a child column outside of its hierarchical parent level.

Pin Columns

You can pin columns to fix them to the left or right side of the table.

Drag the column from the header to one of the following:
  • To pin to the left side of the table, drop the column over the area with the select all check box.
  • To pin to the right side of the table, drop the column on the right when the icon on the column header changes to a pin icon.

You can pin multiple columns.

To remove a pinned column, drag the column back to the main table.

Resize Chemistry

You can change the size of the chemistry in a table column.

Drag the right edge of the chemistry column header.

Chemistry in a table cell has a minimum width size, but does not have a maximum width. The height of the chemistry automatically adjusts according to the chemistry cell size.

Hover over a chemistry cell to view a larger image of the chemistry.