: Wednesday, February 23, 2000 7:54 PM
To: [EMAIL PROTECTED]
Subject: Re: MI Find duplicates in a column of MapInfo table
We have been processing large amounts of plot based development data. Often
we get multiple applications for one plot, and just as you want, only one
instance of each ID. The
Have you tried using the "count()" aggregate function in the sql select
dialog. This will produce a query table containing a column of all
unique occurances of your nominated column in the base table, a count of
how many times this value/entry occurs, plus any other columns you
nominate. Usi
uations I encounter.
Regards,
Keith
> Date: Thu, 24 Feb 2000 13:54:03 +1100
> To:[EMAIL PROTECTED]
> From: Peter Robinson <[EMAIL PROTECTED]>
> Subject: Re: MI Find duplicates in a column of MapInfo table
> We have been processing large amou
We have been processing large amounts of plot based development data. Often
we get multiple applications for one plot, and just as you want, only one
instance of each ID. The easiest way was to export the table to Excel,
sort on the column and remove the duplicates. If any one knows an easier
wa