Exclude duplicity

Hi Elaine,

Do in your IDEA file you have transactions with the same record number and you want to remove them?  One way is to do a summary by record number and then select either the first or last record to get all your transactional data from.  This assumes that the entire transaction is a duplicate.

You would select the Fields and select all the fields and then you have the option to use fields from first or last occurrence.  

Let me know if this works for you or give me more info on your file.

Oh! So easy! Thanks a lot.

Glad it worked for you.