<div dir="ltr">Matt, once I built the array of arrays, your solution worked brilliantly. Thank you!<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Mar 25, 2014 at 11:22 AM, Matt Musgrove <span dir="ltr"><<a href="mailto:MMusgrove@efji.com" target="_blank">MMusgrove@efji.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Lisa,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">If for whatever reason you aren’t able to do this from within Oracle, try the following:<br>
<br>
#!/opt/perl/bin/perl</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> use strict;</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> use warnings;</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> use Data::Dumper;</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> my $markets = [</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> [ 'Market1', 65000, 3000 ],</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> [ 'Market1', 130000, 5000 ],</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> [ 'Market1', 65000, 4500 ],</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> [ 'Market2', 65000, 3000 ],</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> [ 'Market3', 32000, 800 ],</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> [ 'Market3', 32000, 1000 ],</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> ];</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> my %market;</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> for my $market ( @{ $markets } )</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> {</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> my ( $name, $high, $low ) = @{ $market };</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> $market{ $name }{high} += $high;</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> $market{ $name }{low} += $low;</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> }</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> print Dumper( \%market );</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Dfw-pm [mailto:<a href="mailto:dfw-pm-bounces%2Bmmusgrove" target="_blank">dfw-pm-bounces+mmusgrove</a>=<a href="mailto:efji.com@pm.org" target="_blank">efji.com@pm.org</a>]
<b>On Behalf Of </b>Lisa Cloutier<br>
<b>Sent:</b> Tuesday, March 25, 2014 11:18 AM<br>
<b>To:</b> <a href="mailto:dfw-pm@pm.org" target="_blank">dfw-pm@pm.org</a><br>
<b>Subject:</b> Re: [DFW.pm] Adding variables together based on commonality of different variable</span></p>
</div>
</div><div><div class="h5">
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I'm playing with the output right now and I think I may have solved it, I'm still in process of writing it out. Thanks for your reply!</p>
</div>
<p class="MsoNormal">Lisa</p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"> </p>
<div>
<p class="MsoNormal">On Tue, Mar 25, 2014 at 11:16 AM, Sri Vedurumudi <<a href="mailto:sri@vedurumudi.com" target="_blank">sri@vedurumudi.com</a>> wrote:</p>
<div>
<p class="MsoNormal"><br>
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 <br>
<br>
</p>
<div style="margin-left:18.75pt;margin-top:22.5pt;margin-right:18.75pt;margin-bottom:7.5pt">
<div style="border:none;border-top:solid #edeef0 1.0pt;padding:4.0pt 0in 0in 0in;display:table">
<div>
<p class="MsoNormal" style="vertical-align:middle"><img src="cid:image001.jpg@01CF481C.931D5150" name="144fa0dcd1628075_144fa0779f67b224_compose-unknown-contact.jpg" height="25" border="0" width="25"></p>
</div>
<div>
<p class="MsoNormal" style="vertical-align:middle"><a href="mailto:staurofilax77@gmail.com" target="_blank"><b>Lisa Cloutier</b></a></p>
</div>
<div>
<p class="MsoNormal" style="vertical-align:middle"><span style="color:#9fa2a5">Tuesday, March 25, 2014 12:12 PM</span></p>
</div>
</div>
</div>
<div style="margin-left:.25in;margin-right:.25in">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:#888888">Hi All,</span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:#888888">This should be easy and I've done similar things before, but I can't seem to get the data structure to output properly.
</span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:#888888">I have data in the following format:</span></p>
</div>
<p class="MsoNormal"><span style="color:#888888">Market1 65000 3000</span></p>
</div>
<p class="MsoNormal"><span style="color:#888888">Market1 130000 5000</span></p>
</div>
<p class="MsoNormal"><span style="color:#888888">Market1 65000 4500</span></p>
</div>
<p class="MsoNormal"><span style="color:#888888">Market2 65000 3000</span></p>
</div>
<p class="MsoNormal"><span style="color:#888888">Market3 32000 800</span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:#888888">Market3 32000 1000</span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:#888888">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,</span></p>
</div>
<p class="MsoNormal"><span style="color:#888888">Lisa</span></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><span style="color:#888888">_______________________________________________<br>
Dfw-pm mailing list<br>
<a href="mailto:Dfw-pm@pm.org" target="_blank">Dfw-pm@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/dfw-pm" target="_blank">http://mail.pm.org/mailman/listinfo/dfw-pm</a></span></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
Dfw-pm mailing list<br>
<a href="mailto:Dfw-pm@pm.org" target="_blank">Dfw-pm@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/dfw-pm" target="_blank">http://mail.pm.org/mailman/listinfo/dfw-pm</a></p>
</div>
<p class="MsoNormal"> </p>
</div>
</div></div></div>
</div>
This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified
that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the
original transmission and its attachments without reading them or saving them to disk. Thank you.
</div>
<br>_______________________________________________<br>
Dfw-pm mailing list<br>
<a href="mailto:Dfw-pm@pm.org">Dfw-pm@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/dfw-pm" target="_blank">http://mail.pm.org/mailman/listinfo/dfw-pm</a><br>
<br></blockquote></div><br></div>