Sorry, I should have been more explicit. Yes, pivot tables with numbers works great. However, I'm looking to create pivot tables (or as OpenOffice.org calls them, DataPilots (huh?)) with text data.
For example, given this input: a b c a b d a x f a x g q b f q b g q x c q x d I could create a pivot table that outputs this: b x a c,d f,g q f,g c,d I used a comma as a field separator, but anything could be used. sqlite has a nice function called group_concat, which does similar to what I'm looking for. Regards, - Robert On Thu, Jun 3, 2010 at 5:02 PM, Mike B. <[email protected]> wrote: > Try www.google.com/linux search for pivot tables Ubuntu. > > http://www.linuxjournal.com/node/1000252 > > http://communities.bmc.com/communities/blogs/linux/2010/03/30/ubuntu-1004-t-minus-one-month > > http://linuxappfinder.com/blog/gnumeric_vs_openoffice_org_calc > > So. Apparently open office calc supports pivot tables. Will this > help out at all? > > > > On Wed, Jun 2, 2010 at 4:54 PM, Robert Citek <[email protected]> wrote: >> Anyone know how to create a pivot table (aka crosstab) using text data in >> Linux? >> >> Googled and found this article which uses Access: >> >> http://en.kioskea.net/forum/affich-149010-pivot-table-text-data >> >> I don't have Access and the process isn't pretty, but that page >> describes what I would like to do. >> >> Worst-case, I could write a perl script, but thought someone here >> might know if something already exists. >> >> Pointers to Google search terms greatly appreciated. >> >> Regards, >> - Robert >> >> -- >> Central West End Linux Users Group (via Google Groups) >> Main page: http://www.cwelug.org >> To post: [email protected] >> To subscribe: [email protected] >> To unsubscribe: [email protected] >> More options: http://groups.google.com/group/cwelug > > -- > Central West End Linux Users Group (via Google Groups) > Main page: http://www.cwelug.org > To post: [email protected] > To subscribe: [email protected] > To unsubscribe: [email protected] > More options: http://groups.google.com/group/cwelug -- Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [email protected] To unsubscribe: [email protected] More options: http://groups.google.com/group/cwelug
