Philip The best way to eliminate dupes is not to save them in the first place. I don't know if you've already imported or are about to but, if importing, then bear the following in mind:
I'd ensure the data are indexed on the primary key columns - the ones that determine if they are dupes. Use the FIND WITH statement to set searching on the key field. Assuming I'm reading in my additional data, to my master, I'd perform it in a DO WHILE loop (FETCH FIRST, then, in the DO WHILE not EOT, FETCH NEXT) With each source record read I'd do a FIND on the master to see if it already exists. If not then don't copy over - get the next source record. If you've already done the import, are there back-up copies so you can redo the import as above? Hope this isn't trying to teach my grandma to suck eggs :-) HTH Terry McDonnell -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 January 2005 20:46 To: Terry McDonnell Subject: MI-L Duplicate Records Query Group, Can anyone give me a heads up on how to eliminate duplicate records in M 7.5. I'm making a new nation wide roads layer and there will be about 300,000-500,000 duplicate records because of the way I've been given the tab files. Each road segment has its own id number. Thanks -------------------------------------------------------------------- Philip Lesnik Research Systems Analyst, Market Research General Growth Properties, Inc. 110 N. Wacker Drive BSC 3-13 Chicago, IL 60606 312-960-2998 312-960-5519 (fax) [EMAIL PROTECTED] -------------------------------------------------------------------- ----------------------------------------- +++++++++++++++++++++++++++++++++++++++++++++++++++++++ Notice: This e-mail including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. �� 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. +++++++++++++++++++++++++++++++++++++++++++++++++++++++ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15023 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15038
