Hi..
I am facing a problem in aggregating some CSV data, using Java.
My input is like this:
G01,38020, XX, 3M EUR, Sep-07,10,23
G01,38020, XX, 3M EUR, Sep-07,11, ,72
G01,38020, XX, 3M EUR, Dec-07,14, ,500
My expected output is:
G01,38020, XX, 3M EUR, Sep-07,10,23, ,
, , XX, 3M EUR, Sep-07,11, ,72,
, , , , , ,23,72,
, , XX, 3M EUR, Dec-07,14, ,500,
, , , , , ,0,500,
Check out the image for convenience:
I need to calculate sum for the values in the last two columns.
Can anyone suggest me on how to approach this problem?
[ July 17, 2008: Message edited by: Ashutosh Deo ]