<html><head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
</head><body text="#000000" bgcolor="#FFFFFF"><br>
<span>Lisa,<br>
Isn't it easier for you to alter the SQL query so it gives you the
data summed up and pre-grouped? <br>
<br>
Regards,<br>Sri </span><br>
<blockquote style="border: 0px none;"
cite="mid:CAGX=xVQXedtVm-22xvFR8BXeXQy8g0_nk1NdAZZTPKtyVHJnsA@mail.gmail.com"
type="cite">
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="staurofilax77@gmail.com" photoname="Lisa Cloutier"
src="cid:part1.01030302.01060204@vedurumudi.com"
name="compose-unknown-contact.jpg" width="25px" height="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true" href="mailto:staurofilax77@gmail.com"
style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Lisa Cloutier</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">Tuesday, March
25, 2014 12:12 PM</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr"><div><div><div><div><div><div><div><div><div><div>Hi
All,<br><br></div>This should be easy and I've done similar things
before, but I can't seem to get the data structure to output properly. <br><br>
</div>I have data in the following format:<br><br></div>Market1 65000
3000<br></div>Market1 130000 5000<br></div>Market1 65000 4500<br></div>Market2
65000 3000<br></div>Market3 32000 800<br></div>Market3 32000 1000<br>
<br></div>What I need to do is get the markets so that they are unique
so that I can use them as hash keys. So I need to add all of the 2nd
column and all of the 3rd column for each market so that there is only
one entry per market, with the duplicate entries all added together. <br>
<br>The data is coming out of an arrayref (from an Oracle database) so I
don't have any code that shows the problem, just the foreach loop
iterating through each reference in the arrayref. <br><br>Any help
would be greatly appreciated. <br>
<br>Thanks,<br><br></div>Lisa<br></div>
<div>_______________________________________________<br>Dfw-pm mailing
list<br><a class="moz-txt-link-abbreviated" href="mailto:Dfw-pm@pm.org">Dfw-pm@pm.org</a><br><a class="moz-txt-link-freetext" href="http://mail.pm.org/mailman/listinfo/dfw-pm">http://mail.pm.org/mailman/listinfo/dfw-pm</a><br></div></div>
</blockquote>
</body></html>