Re: Accumulating Column Total From a CSV for a Common Key Value

On Monday 27 August 2007 12:36:02 country wrote: > s2pe,CTI Production ,8455,21.7% > sybprd01,OMS,5326,13.7% > pctip01,CTI,5098,13.1% > lxsadr54,CTI,1742,4.5% > pipmp01,SSG-IPM,1742,4.5% > maestro,SSG-RAC-Maestro ,1020,2.6% > f2pa,"DB2DARI  ""stored procedures"" prod",836,2.1% > pomgp01,SSG-PMD-Ome

Re: Accumulating Column Total From a CSV for a Common Key Value

country wrote: Login ID,Application,CPU Minutes,Percent of Total s2pe,CTI Production ,8455,21.7% sybprd01,OMS,5326,13.7% pctip01,CTI,5098,13.1% lxsadr54,CTI,1742,4.5% pipmp01,SSG-IPM,1742,4.5% maestro,SSG-RAC-Maestro ,1020,2.6% f2pa,"DB2DARI ""stored procedures"" prod",836,2.1% pomgp01,SSG-PMD-

Accumulating Column Total From a CSV for a Common Key Value

I'm working with 100's of PS Account 'MONTHLY USAGE' Reports. I have been able to parse the reports, do a table lookup to match a Login ID with an Application Name. My output CSV at this point is as follows: Login ID,Application,CPU Minutes,Percent of Total s2pe,CTI Production ,8455,21.7% sybprd0