Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unique Record Table
Message
De
17/07/1997 21:32:31
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
 
 
À
16/07/1997 22:23:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00040341
Message ID:
00040495
Vues:
28
Is uniqueness based on a single field or a combination of fields for a record to be considered "unique"?

>>As part of my thesis at Navy Postgraduate School, I have a genetic algorithm that runs in MS VFP 5.0. The output of the GA is a table with approximately 15 fields and usually about 5000 unique records. Every time I run the GA, I save the output in a table archive. Now, I have approximately 20 tables in the archive.
>>
>>I would like to create a new table which retrieves only the unique records from each of these 20 archived tables. There are no repeat records within each table. Again, each table has the same structure. I have tried appending records, which works, but it does not eliminate repeats. Is there a way of automatically eliminating repeats after the appendage? Or is there a method of using the 'join' (or some other) feature to do this? For each table, there is approximately 20%-30% intersection, so doing it manually is out of the question.
>>
>>Thank you,
>>LT Jason W. Carter
>>U.S. Navy
>
>Jason, How about this... If the records which you do not want repeated are exact duplicates append all of them into one file, then use an SQL-Select something like this to get your unique records. "Select distinct * from appended_table into table new_table"
L.A.Long
ProgRes
lalong1@charter.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform