Arrays

[#1]

I have a record that has a control, year and month (A record for each month, months can be skiped)

Input

  Record              Control     Year     Month

     1                           A          2011       02

     2                           A          2011       04

     3                           A          2011       06

     4                           A          2011       07

     5                           B          2011       03

     6                           B          2011       04

I need to build an array grouped by Control and Year

like the following

                                  A          2011      02,04,06,07

                                  B          2011      03,04

[jonathandienst]

Dick

Assuming the data has already been loaded into table RawData...

Arrays:
LOAD Control,
     Year,
     Concat(Month, ',') As MonthArray
Resident RawData
Group By Control, Year
;

(adjust as required)

Regards

Jonathan