I am trying to retain my map objects while removing
duplicates. For some reason I am unable to do so. I am
following the exact steps given in the Mapinfo
knowledge base site. It is as follows
The following procedure will produce a final table
with map objects and no duplicate records .
Start with the table that has the duplicate records.
Choose Table>Maintenance>Table Structure and add a
field to the table. Call it Row_Number for example.
Make sure it is of type Integer.
Next, go to Table>Update Column and update the column
with RowID.
Next, go to Query>SQL Select. Select the table from
the Table dropdown and then click in the Group by
Columns field and select a column from the Column
dropdown.
Click OK and a Query1 browser will be returned. Choose
File>Save Copy As and select Query1 and click Save As.
Rename the Query1 table with a more meaningful name
and click save. For this example, it will be called
GroupedTable.
Choose File>Close Table and close the Query1 table.
Choose File>Open Table and open the new GroupedTable.
It should open as a browser and have no map associated
with it.
Next, choose Query>SQL Select.
>From the Table dropdown, select the original table
first, then select the grouped table as shown below.
In the where Condition, join the two tables on the
Row_number column.
Choose File>Save Copy as and select the current Query#
and then rename the Query to another name. Click Save.
Choose File>Close Table and close the query. Choose
File>Open Table and open the copy that was just saved.
This is the final version of the table.
The map objects will now be restored and the duplicate
rows will be gone.
--------
After doing it, I still can�t retain map objects, how
else can I retain the map objects, please help
Namita
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16039
