Sorting Data in a Browser Window - MapInfo_Pro - 2023

MapInfo Pro Help

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
Version
2023
Language
English
Product name
MapInfo Pro
Title
MapInfo Pro Help
First publish date
1985
Last updated
2023-09-12
Published on
2023-09-12T16:39:16.995549

To do a simple sort, which is only sorting by one column, right-click on any cell in the column including its header and then choose the sort option that you want from the popup menu. After sorting, icons display at the top of the sort column(s) to provide visual confirmation of the sort. If you save a workspace, the sort order is preserved.

To perform a multi-column sort:

  1. On the TABLE tab, in the Sort and Filter group, click Sort, and Sort Multi Column.
  2. Select column and order type from the Sort by lists.
  3. Refine your sort further by selecting another column and order type to apply to your sort from the Then by lists.
  4. Click OK to close the dialog and sort the contents of the Browser window.

The sort result displays in a new Browser window, and the sort order is in the order of the columns you select.

This example shows a sort result on the Country column:

Country City Landmark

Germany

Berlin

Fernsehturm

Germany

Berlin

Brandenburg Gate

India

New Delhi

Qutab Minar

India

New Delhi

Jama Masjid

India

Jaipur

Hawa Mahal

India

Maharashtra

Ajanta

United Kingdom

London

Buckingham Palace

United Kingdom

Blackpool

Blackpool Tower

This example shows a sort result on the columns Country, then City, then Landmark:

Country City Landmark

Germany

Berlin

Brandenburg Gate

Germany

Berlin

Fernsehturm

India

Jaipur

Hawa Mahal

India

Maharashtra

Ajanta

India

New Delhi

Jama Masjid

India

New Delhi

Qutab Minar

United Kingdom

Blackpool

Blackpool Tower

United Kingdom

London

Buckingham Palace

If you sort a Browser window and then edit that table, the Browser window may turn the sort off. Specifically, any edit operation that adds new rows to the table causes the Browser window to unsort, so that newly-added rows are visible at the bottom of the window. Note that this unsorting can occur even if you add new rows in a different window (for example, if you add new rows by drawing new lines in a Map window). After adding a new row to the table, you can re-apply the sort to the Browser window on the TABLE tab, in the Sort and Filter group, click Sort On/Off.