Your skill will accomplish
what the force of many cannot
Combine data in tableby DrAxeman (Beadle)
|on Aug 07, 2005 at 16:54 UTC||Need Help??|
DrAxeman has asked for the
wisdom of the Perl Monks concerning the following question:
I am trying to combined data in a csv file. The data looks like:
What I am looking for is the deletion of the 2nd column, and then for all the rows who are the same in the first field, a sum of the 3rd and 4th fields. There could be 1 to 4 rows with the same data in field 1. Output should look like.
If this were columns I think I could do it, but since it's rows I'm not sure of the SQL.