Maptitude - http://research.umbc.edu/~roswell/maptitude.html
We have had a lots of excellent suggestions on counting duplicate
records. Let me add my favorite method which demonstrates the
power of Maptitude joins.
You can use Maptitude to create a one-to-many join on the field for
which you want to count duplicates. In the standard aggregation
for the join, a field will appear containing the number of records
behind each value.
For Kevin's problem, I would start by modifying the table to
contain a count field. We fill it with the count of duplicates as
follows:
Create a formula field that contains the combined
Longitude/Latitude for the points. The formula could be:
i2s(Latitude) + "," + i2s(Longitude)
Now choose Dataview-Join and make sure the option tabs has "Allow
all types of joins" checked, and select One-to-Many Join. On the
main tab, select to join the table to itself on the formula field.
If the view was named "Data", the resulting join will have a field
called [N Data]. You can fill the Count field with [N Data]. Now
drop the join, and you have your result: the Count field contains
the number of duplicate points.
-Kjartan
______________________________________________________________________
To unsubscribe, write to [EMAIL PROTECTED]
