Hello Andreas, Thank you for your message and your patience.
I am attaching two files - the first one outlines what I am hoping to accomplish and the second one has three tables in a worksheet that provides a shortened typical entry of the files involved and what I hope to see as a result
Hope this provides enough info so that someone can point me in the right direction
Thanks again, Preston On 8/7/2011 1:12 PM, Andreas Säger wrote:
Let me retry your request in this way: 0) Technical prerequisites: Running LibreOffice 3.3.3 under WinXP I have a spreadsheet with 2 tables imported from text files which I receive on a regular basis from other departments of our organization. 1) A list of persons with an ID number, name, forname, birthday, address info and more: 0 Smith Jennifer 1967-07-09 ... 1 Smith John 1988-07-29 ... 2 Doe Farina 1999-11-12 ... 2) A membership list with person ID, entry date, department 1 2003-12-03 Helsinki 2 2007-01-01 Stockholm 0 2010-11-11 London 2 2009-01-31 Berlin 3)Now I want to merge both lists so they look like Smith John 1988-07-29 2003-12-03 Helsinki ... Doe Farina 1999-11-12 2007-01-01 Stockholm ... Smith Jennifer 1967-07-09 2010-11-11 London ... Doe Farina 1999-11-12 2009-01-31 Berlin ... where the membership's person-ID is merged with the membership information. This entirely technical information about what you have and where you want to go could serve as a platform where anybody on this list could be involved with some hints, tips, suggestions how to process these concrete example data in a spreadsheet, in a database, in a scripting language. Example data can be copied into a spreadsheet very easily and from there into a database.
-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted