Exclude duplicity
ElaP
Forums
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
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
Hi Elaine,
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.