Information générale
Catégorie:
Codage, syntaxe et commandes
>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"
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement