Andreas Saeger wrote:
Download my database http://www.mediafire.com/?ydzh0thjzyy
Clear my test data from table "Data".
Open the table, select all rows (click the grey top-left corner) and
delete the rows.
Alternatively: menu:Tools>SQL... DELETE FROM "Data"
Register my database in menu:Tools>Options...OOo Base>Databases
Open your spreadsheets and import your data.
Create a data pilot.
Sorry I uploaded another version of that database collect2.odb
http://www.mediafire.com/?hdnnzivdnzi
It includes 2 queries:
- qDupesInfo collects information about duplicate pairs of "Name" and
"Value".
- From that query, qDeleteDupes shows all duplicates except the ones
with the lates time stamp. You can delete your dupes directly in the
beamer without opening any database file.
Select query qDeleteDupes in the left pane
Click the grey, upper-right corner in the right pane to select all records.
Right-click>Delete
How to design the database that it won't accept any duplicates of "Name"
and "Value":
- Delet all existing duplicates as described above.
- Open the database (you can do so with a right-click on the DB in the
beamer)
- Select table "Data"
- menu:Edit>Edit... (or right-click>Edit...)
- you get the table editor where you define the *structure* rather than
content.
- menu:Tools>Index Design...
- add new Index using the [*]-icon, give some name (say "uniqueNV"),
check the "unique" checkbox, add Name and Value to the index, save the
index and close the index designer and the table designer.
The table won't accept equal pairs of Name and Value anymore. When you
import your spreadsheet data and the data contain a certain pair that is
in the database already, you get a warning message and you can choose
"Continue" which will continue the import but skip the duplicates.
If you want to disallow all combinations of Value and Name in the same
import session (the same time stamp) simply add the stamp to the index
definition, which will reject duplicate combinations of Name, Value and
Stamp then.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
