combine duplicate rows in mapinfo table

[Bob]

Hi all,

I have a polygon table that has rows where some of the rows, the Name
column is identical, but both rows contain a different polygon. I
need to have only one polygon with one name, instead of 2 or more
polygons with the same name. (For example-New York City is listed 5
times in the table because it contains 5 seperate polygons).

Is there a way to combine the rows together where the names match? If
anyone knows of a way in sql or maybe an mbx I would appreciate it.

Thanks,
Bob

[Peter Horsbøll Møller]

Bob,

In the Table menu you'll find the function called Combine objects using column....
This will let you combine records with the same value in a specified column

Peter Horsbøll Møller
GIS Developer, MTM
Geographical Information & IT

COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark

Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail p...@cowi.dk
http://www.cowi.dk/gis

"Syn for sagen" er temaet for dette års MapInfo konference 2007.
Se programmet for konferencen her: http://www.cowi.dk/mapinfokonference

[Bob]

Thank you. The Table->combine objects using column, is exactly what I
was looking for. I forgot that feature existed.

Thanks again,
Bob

On Jun 21, 11:08 pm, Peter Horsbøll Møller <P...@cowi.dk> wrote:
> Bob,
>
> In the Table menu you'll find the function called Combine objects using column....
> This will let you combine records with the same value in a specified column
>
> Peter Horsbøll Møller
> GIS Developer, MTM
> Geographical Information & IT
>
> COWI A/S
> Odensevej 95
> DK-5260 Odense S.
> Denmark
>
> Tel +45 6311 4900
> Direct +45 6311 4908
> Mob +45 5156 1045
> Fax +45 6311 4949

> E-mail p...@cowi.dkhttp://www.cowi.dk/gis

>
> "Syn for sagen" er temaet for dette års MapInfo konference 2007.
> Se programmet for konferencen her:http://www.cowi.dk/mapinfokonference
>
>
>
> -----Original Message-----
> From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf OfBob
> Sent: Thursday, June 21, 2007 10:12 PM
> To: MapInfo-L
> Subject: [MI-L] combine duplicate rows in mapinfo table
>
> Hi all,
>
> I have a polygon table that has rows where some of the rows, the Name column is identical, but both rows contain a different polygon. I need to have only one polygon with one name, instead of 2 or more polygons with the same name. (For example-New York City is listed 5 times in the table because it contains 5 seperate polygons).
>
> Is there a way to combine the rows together where the names match? If anyone knows of a way in sql or maybe an mbx I would appreciate it.
>

> Thanks,Bob- Hide quoted text -
>
> - Show quoted text -