Jump to content

List Unique Occurances


This topic is 6103 days old. Please don't post here. Open a new topic instead.

Recommended Posts

This may be an easy one but I'm stumped.

I have a db with the fields firstname, lastname and other data. I'm importing records from an excel spreadsheet. I get multiple firstname/lastname combinations. I'd like to get a unique list of all the the firstname/lastnames without the multiple repeats. I can't figure out how to do this.

Much obliged for any help.

Cheers,

MJ

Link to comment
Share on other sites

Hate to discourage you, but finding duplicates after import is not easy. The crux of the matter is "What is a Duplicate?" If you can come up with a DupCheck calc field, then in Find mode you can search for records that have the same data in DupCheck by using the "!" symbol (the DupCheck field must be set to be Unique). Check out John Mark Osborne's tip: Isolating Duplicates

I think you'll end up with a found set of possible duplicates that you'll let the user view and delete the records that they've decided are the real duplicates. Then, you'll have to help them with the appropriate warnings when they delete (for example, what if they are deleting a record that has children?).

Link to comment
Share on other sites

This topic is 6103 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.