Sorry, I should have clarified that.

If the Title, Table and Field combination appears more than once, then it's a duplicate.



>What is the definition of a duplicate here?
>
>>I have a table with this structure:
>>
>>

>>Sec Tp Title                         Table      Field
>>---------------------------------------------------------
>>    CR cash balance between 300.rpt  trades     tradedate
>>    CR cash balance between 300.rpt  trades     valuedate
>>    CR cash balance between 300.rpt  cust       acctname
>>    CR cash balance between 300.rpt  trades     conf_num
>>    CR cash balance between 300.rpt  trades     product
>>    CR cash balance between 300.rpt  trades     quantity
>>    CR cash balance between 300.rpt  trades     price
>>    CR cash balance between 300.rpt  trades     ext_price
>>    CR cash balance between 300.rpt  trades     productbal
>>    CR cash balance between 300.rpt  trades     cash_bal
>>3.1 CR invoice prior posting.rpt     trades     product
>>3.1 CR invoice prior posting.rpt     trades     quantity
>>3.1 CR invoice prior posting.rpt     tranfile   tranquant
>>3.1 CR invoice prior posting.rpt     prods      prodesc
>>3.1 CR invoice prior posting.rpt     trades     price
>>3.2 CR open customer positions.rpt   trades     tradedate
>>3.2 CR open customer positions.rpt   trades     tradetype
>>3.2 CR open customer positions.rpt   trades     product
>>3.2 CR open customer positions.rpt   trades     quantity
>>3.2 CR open customer positions.rpt   trades     price
>>3.2 CR open customer positions.rpt   trades     net_amount
>>3.2 CR open customer positions.rpt   trades     cash_bal
>>3.2 CR open customer positions.rpt   trades     conf_num
>>3.2 CR open customer positions.rpt   trades     productbal
>>3.2 CR open customer positions.rpt   trades     valuedate
>>

>>
>>How do I remove the duplicate rows?