We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

How do you delete duplicate records in Paradox 7

paulanderson
paulanderson asked
on
Medium Priority
748 Views
Last Modified: 2009-12-16
I am using paradox 7 I have inherited a database which
has about 6500 enteries. I have noticed that there is a number of duplicate records but I can not see a way to
get rid of these. There is three keys which I would like to check (phoneres, Fname and Lname) if these three fields combined are identical I want to get rid of the entire record.
Comment
Watch Question

Author

Commented:
Adjusted points to 100
Commented:
I am not a Paradox guru, but let me describe a general technique that you may be able to use.  It involves a multiple step process.

1). You create a view that is sequenced on your duplicate keys, grouped by your keys, and you create a calculated field that is a count of each member in an identical group.

2) You can now identify your duplicated records as only those with a group count greater than one.

3) You can create another view with only dupe keys. Then use that view to join/delete against your original table.

4) If you want to insert back one of the duplicates, make sure you include all the original columns in you table, then after deleting all dupes, you can insert back one from each duplicated group by using your sequenced and grouped view from step one.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
You could perhaps save a database file, and do the indexing as proposed by cymbolic, do a sequential pass thru the file, comparing current record to last record, and dump any which are dup's.

This requires no counting and requires only one pass through the data.

Cheers!

Chris Maylor

Commented:
You could perhaps save a database file, and do the indexing as proposed by cymbolic, do a sequential pass thru the file, comparing current record to last record, and dump any which are dup's.

This requires no counting and requires only one pass through the data.

Cheers!

Chris Maylor

Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.