Hi,
I want to merge records from different records with the same keyvalue and I wonder hos this can be done.
My file is fixed blocked with recordlength 11 and the key i position 1-4 and a numeric value in position 5-11.
The file contains following records:
2009 4520
2010 4701
2011 6613
2009 416
2010 388
2011 614
2009 257
2010 235
2011 260
I want all records that have key 2009 to look like this (from the three records)
2009 4520 416 257
and the same for 2010 and 2011
2010 4701 388 235
2011 6613 614 260
Mike