Table Analyse

For: MapInfo Pro/MapBasic

By: Peter Horsbøll Møller

Rated: 5 Stars (1 rating)

Have you ever needed a tool that helps you dive into the details behind your tables?

Well here it is: Table Analyse

The tool Table Analyse started out as a tool that I created for a workshop some years back. Over the last years I have added extra features to it and I guess now is the time to share the tool.

Here is how to start it:

1. Start the tool as any tool from Tools > Run MapBasic Application

2. The tool will get embedded in your Tools menu, as the new menu called Table Analyse.

3. If you find the tool useful you can add it to the Tool Manager and have it autoloaded.

Now let's look at the functionality

1. Open one or more tables that you want to dive into

2. Now goto Tools > Table Analyse > Analyse Open Tables. The dialog Table Analyse will appear.

3. Select one of the tables in the dropdown list Open Tables.

4. You can now inspect the details about this table. It's type, the coordinate system, the data bounds  And you can see the columns and their type in the table as well.

5. Click one of the columns in the list Column Information.

6. The tool will now analyse the data in the selected column and give you some statistics about this column, such as the number of unique values and a list of the top 100 unique values. If you selected a numeric column you'll also see the minimum and maximum value in the column

7. Now double click one of the unique values in the list.

8. The tool now selects all the records with this value. The data is selected into a names query and add to the front most map window, or inserted into a new map if you don't have any open.

9. Also note that the tool also inspects your spatial data if you click the Object column.

Have fun!

Oh, and the tool does come with the MapBasic code in case you want to modify it