Pitney Bowes MapInfo Professional - Manual (Page 132)

6. Click OK. MapInfo Professional creates a query table of the southeastern states with the District
column containing the value Southeast.
7. Save the table to preserve the new information.
Appending Rows to a Table
Use the Append Rows to Table command to attach the records from one table to another. The two tables
should have the same set of columns in the same order.
To append data to another table:
1. On the Table menu, click Append Rows to Table. The dialog box displays.
2. Specify the table containing the records you want appended.
3. Specify the table to which the records will be appended and click OK.
If the corresponding columns do not have the same data type, a best fit is done to convert the data to
the appropriate type. If the order of the columns is not the same between the two tables, use the Table
Structure command to reorder the columns before using Append Rows to Table.
If tables are mappable, the bounds of the map in one table must be large enough to allow objects
from the other table to fit within it. Otherwise, the objects will be distorted to the bounds of the Note:
Map window. Use the Check/Set CoordSys Bounds tool to alter the map bounds of the table if
this occurs. See
Using the Tools in the Tool Manager for more about the CoordSys Bounds
tool.
Appending One Table to Another
To append one table to another:
1. Choose Table > Append Rows to Table. The Append Table dialog box displays.
2. Choose the table you want to append from. Select a table in the Append Table drop-down list.
3. Choose the table you are appending to. Select a table in the To Table drop-down list.
4. Click OK. The status of the append operation displays.
5. Click Stop to halt the append process.
When the columns of the two tables are not ordered properly, so that columns with corresponding
positions do not have corresponding data, use Modify Structure to change the order of the columns in
one of the tables.
You can use SQL Select to reorder the columns of one of the tables and then append the results.
Parsing Data from One Column to Multiple Columns
If you have imported data into MapInfo Professional from another format, there is always the chance
that the data will not come in exactly the way you want it. In some instances, items that should appear
in separate columns may be put together in one column. The following is a series of column updates
that parses one column of full names (first, middle, and last) into three parts. It works even if there is no
middle name, or if there is only a last name.
To parse data from one column to multiple columns:
1. On the File menu, click Open and open the table to be modified.
2. Add three new columns to your table. On the Table menu, point to Maintenance and click Table
Structure. Add two character columns of size 15. Call them FIRST and MIDDLE. Then add a character
column called LAST of size 30.
3. Put the full name into the column called LAST by choosing the Table menu, and clicking Update
Column. Fill in the Update Column dialog box.
MapInfo Professional 12.5 132
Working with MapInfo Tables