Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove Duplicate Rows
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01321346
Message ID:
01321351
Vues:
14
I don't see any duplicates here...

>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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform