Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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