Re: [sqlite] Degrouping, desummarizing or integrating headings

T wrote: It comes as a CSV or tabbed text file, then into a table in my database. So, it's in a table in my database, eg: CREATE TABLE Shopping_Grouped(Aisle TEXT, Product TEXT, Cost REAL) But the Aisle entries are in records by themselves, and apply to the subsequent records containing

Re: [sqlite] Degrouping, desummarizing or integrating headings

at should be trivial depending on your programming environment. But is it possible via SQL? Thanks, Tom From: T <[EMAIL PROTECTED]> Date: 14 March 2007 3:07:24 AM To: sqlite-users@sqlite.org Subject: [sqlite] Degrouping, desummarizing or integrating headings Hi All, I come across

Re: [sqlite] Degrouping, desummarizing or integrating headings

On 3/13/07, T <[EMAIL PROTECTED]> wrote: Hi All, I come across a fair bit of source data in summary format, where the one field's values are used as a heading for a group of records for which it applies. For instance, this shopping list: Aisle Product Cost Dairy Milk

[sqlite] Degrouping, desummarizing or integrating headings

Hi All, I come across a fair bit of source data in summary format, where the one field's values are used as a heading for a group of records for which it applies. For instance, this shopping list: Aisle Product Cost Dairy Milk $2 Cream$1