Controlling data display

Within data tables, there are features that you can use to control how data is displayed, such as sorting and setting column order.

Sorting the table

You can sort by one or more columns in data tables.

Sort a table

1. Click header to sort in ascending order.
2. Click header a second time to sort in descending order.
3. Click header a third time to clear the sort on that column.
4. To sort by more than one column, hold the Shift key while clicking the column header.
5. Click Clear Sorts to clear the sorting on all columns.

Freezing columns

You can freeze one or more columns at the left side of the data table. In this way, you can keep specific columns displayed while you scroll through other columns in the table. This is very useful for tables with a large number of columns. You can freeze columns in:

• Input Tables
• Output Tables
• Views
• Map Layer Data Tables

Freeze columns and split the table

1. Hover your cursor over the small vertical bar at the far left of the table. The cursor changes to a double-pointed arrow.

   

2. Drag the bar to where you want to split the table. Columns to the left of the bar are frozen and you can scroll through the columns to the right.

Column options

You can manually adjust column widths in input and output tables. The widths you set are persisted when you reopen the table.

Reorder columns

Drag and drop columns within the table to the desired position.

Show/hide columns

Right-click on the column and select Hide Column.

Alternately, you can right-click on the column header row. You see a form with the names of all table columns. Uncheck the names of columns that you do not want to display. These columns will not be displayed, but any data in the model database field is maintained. To display the columns, right-click on the column header row and check the names of columns you want to display.

Formatting columns

For columns that are stored as numbers or dates, you can override the Data Formats (as set in Model Settings) on a column-by-column basis.

Set the format for a column

1. Click the column features icon on the column you want to format.
   If the column stores values in a text field, Format Column will not be available.
2. Select Format Column. You see the Preview of the currently selected format.
3. Select the format you want to use from the drop-down list.
4. If you want the selected format to be used as the default for all columns of this type (Date, Number or Currency), select Use As Default.
5. If you want to return to the default format as set in Model Settings > Data Formats, click Set Defaults.
6. Click OK. The currently selected format will be applied to the current column. If you checked Use As Default, the format is applied to all columns of this type.

Displaying the sum row

You can display a row that shows the sum for numeric fields in data tables.

Display the sum row

1. Open the data table.
2. Click Sum Row. A row is displayed at the bottom of the data table with the sum for each numeric value. The sum is based on which records are currently displayed, so totals will change when filters are applied.