On Dec 19, 2003, at 8:41 AM, Dok, D. van wrote:
MS Access has a 'TRANSFORM' function to do this, which transposes the
data
along a pivot.
You'll probably want to look at Joe Conway's tablefunc. It's in
contrib. It's included in 7.4; I'm not sure about 7.3.4, but you can
add it if it's not.
Hope
Hello,
I'm writing this bit because it adresses a common problem, but uses a
different solution.
In a simple data model of timeseries, we have a table with fields v (for
variable), t (for time) and y (the data value). v,t is the primary key.
It is sometimes desireable to have a side-by-side comp
