September 11, 200223 yr hi everybody,... i need help to make the following script: 1. find all the duplicate records - this i know how... 2. delete all the duplicates but keep the one with the most recent date... 3. if all the duplicates have the same date keep only one... any help will be appreciated.... thanks...
September 11, 200223 yr Once you have found all the records that are duplicates you need to omit the records that you wanna keep. I would first sort by something that would identify the record and its duplicates (Account Number or something) then sort by your date. Now you need to loop through the records and omit the one with the most recent date. Once done, you will have your set that you can delete.
Create an account or sign in to comment