Skip to main content

Exclude duplicity

Hello everyone
I need some help. Does anyone know how to exclude duplicates from a table, for example by record number?
Thank in advance.
Elaine

Brian Element Wed, 06/28/2023 - 08:18

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.