|Easy Tip! Sort across multiple columns in a Browser window |
| || |
This article pertains to both the 32-bit (version 11.0 and later) and the 64-bit version of MapInfo Pro.
The Browser window provides easy one click sorting but did you know that with just a few more clicks you can sort across multiple columns? For example it is possible to sort a table of customers by last name, then first name and then by their order amount.
Another example is, given a table of cities in the USA first sort the cities by what State they are in and then sort by their population in descending order. Below is a screen shot of the data we will use.
The data in the map above is part of the sample data that comes with MapInfo Professional. The data has not been sorted yet.
The Sort/Filter menu
In the 32 bit version of MapInfo Pro the Browser window tool bar has a Sort / Filter menu as seen below. The first command is Sort Multi-Column...
In the 64-bit version of MapInfo Pro, the Table tab has a Sort and Filter Group. The Sort drop-down includes the Sort Multi Column... command
Below is the Sort dialog box. It is filled to sort the city table first by State and then by Total Population.
You can sort up to five columns.
The following is the resulting Browser window.
The cities are now sorted alphabetically by State and then in descending order by population within the state.
Save a workspace
If you wish to save and recall the Browser as it is sorted, just save a workspace!
Turn the result into a query table
The view in the Browser can be turned into a query table.
- 32 bit MapInfo Pro: In the Sort/Filter menu choose Create a Query from the Browser Contents.
- 64 bit MapInfo Pro: On the Table tab, use the Add to Map button. This is in the Sort and Filter group as pictured above.
Do you have questions?
Why not join our LinkedIn Group.
Feel free to post questions and I'm always happy to get suggestions for topics to appear in this journal.
Article by Tom Probert, Editor of "The MapInfo Professional" journal
When not writing articles for "The MapInfo Professional", Tom enjoys talking to MapInfo Professional users at conferences and events. When not working he likes to see movies with car chases, explosions and kung-fu fighting.