Date:         Mon, 4 Dec 1995 15:37:54 +0000
Reply-To:     The NOMAD2 Discussion List
Sender:       The NOMAD2 Discussion List
From:         Alan Long
Subject:      Creating an array

I have a database with a schema like:

     Key      product as a8;
     Key      weekno  as 99;
     Item     qty     as 99999;

     weekno is the week number with the current week = 1 and with a
maximum value of 52.

     I need to create a database from this but with weekno and qty
transformed to an array:

     Key   product as a8;
     Item  qty(52) as 99999;

So, for example, data like this:

     product    weekno    qty
     ABC           2      1000
     ABC           4      2000

produces data like this:

     product
     ABC      qty(1) = N/A   qty(2) = 1000   qty(3) = N/A   qty(4) = 2000

     Is there a simple and elegant way to do this (I can think of some
horrendously clumsy ways!).

Regards,
Alan Long
back to index