Deduplicate?

[CharityBrowser]

Thanks David & Jim, I appreciate the help!

--FTP

On Feb 9, 2008, at 6:33 PM, David Thompson wrote:

>> Hello,
>>
>> I have a list sorted so that the duplicate records in my DB are shown
>> (sorted up). What I'd like to do now is remove all but one of each
>> duplicate record (sometimes there are two duplicates, sometimes there
>> are three). The field I'm using to identify the duplicates is Orgname.
>>
>> Does anyone know of a procedure for this?
>
> The Unpropagate command can be a big help with this. If you make your
> Orgname field the active field and do an Unpropagate, then whenever a
> value matches the one in the preceding record it will be changed to a
> blank, so then you can select just the records that have a value in
> that field and remove the rest.
>
> Field Orgname
> Unpropagate
> Select Orgname <> ""
> RemoveUnselected
>
> Dave
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna
>
>