[DFW.pm] Adding variables together based on commonality of different variable

[Matt Musgrove]

Lisa, that's great but this is really just a short-term fix. The long term solution, as others have said, should be dealt with in the query. I know that you'll figure it out. :)

From: Dfw-pm [mailto:dfw-pm-bounces+mmusgrove=efji.com at pm.org] On Behalf Of Lisa Cloutier
Sent: Tuesday, March 25, 2014 11:52 AM
To: dfw-pm at pm.org
Subject: Re: [DFW.pm] Adding variables together based on commonality of different variable

Matt, once I built the array of arrays, your solution worked brilliantly.  Thank you!

On Tue, Mar 25, 2014 at 11:22 AM, Matt Musgrove <MMusgrove at efji.com<mailto:MMusgrove at efji.com>> wrote:
Lisa,
If for whatever reason you aren't able to do this from within Oracle, try the following:

                #!/opt/perl/bin/perl
                use strict;
                use warnings;
                use Data::Dumper;

                my $markets = [
                                [ 'Market1', 65000, 3000 ],
                                [ 'Market1', 130000, 5000 ],
                                [ 'Market1', 65000, 4500 ],
                                [ 'Market2', 65000, 3000 ],
                                [ 'Market3', 32000, 800 ],
                                [ 'Market3', 32000, 1000 ],
                ];

                my %market;
                for my $market ( @{ $markets } )
                {
                                my ( $name, $high, $low ) = @{ $market };
                                $market{ $name }{high} += $high;
                                $market{ $name }{low} += $low;
                }

                print Dumper( \%market );

From: Dfw-pm [mailto:dfw-pm-bounces+mmusgrove<mailto:dfw-pm-bounces%2Bmmusgrove>=efji.com at pm.org<mailto:efji.com at pm.org>] On Behalf Of Lisa Cloutier
Sent: Tuesday, March 25, 2014 11:18 AM
To: dfw-pm at pm.org<mailto:dfw-pm at pm.org>
Subject: Re: [DFW.pm] Adding variables together based on commonality of different variable

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!
Lisa

On Tue, Mar 25, 2014 at 11:16 AM, Sri Vedurumudi <sri at vedurumudi.com<mailto:sri at vedurumudi.com>> wrote:

Lisa,
    Isn't it easier for you to alter the SQL query so it gives you the data summed up and pre-grouped?

Regards,
Sri
[cid:image001.jpg at 01CF4820.F7574A00]
Lisa Cloutier<mailto:staurofilax77 at gmail.com>
Tuesday, March 25, 2014 12:12 PM
Hi All,
This should be easy and I've done similar things before, but I can't seem to get the data structure to output properly.
I have data in the following format:
Market1 65000 3000
Market1 130000  5000
Market1 65000   4500
Market2 65000  3000
Market3 32000  800
Market3 32000  1000
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.

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.

Any help would be greatly appreciated.

Thanks,
Lisa
_______________________________________________
Dfw-pm mailing list
Dfw-pm at pm.org<mailto:Dfw-pm at pm.org>
http://mail.pm.org/mailman/listinfo/dfw-pm

_______________________________________________
Dfw-pm mailing list
Dfw-pm at pm.org<mailto:Dfw-pm at pm.org>
http://mail.pm.org/mailman/listinfo/dfw-pm

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.

_______________________________________________
Dfw-pm mailing list
Dfw-pm at pm.org<mailto:Dfw-pm at pm.org>
http://mail.pm.org/mailman/listinfo/dfw-pm

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/dfw-pm/attachments/20140325/f15dfda6/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 770 bytes
Desc: image001.jpg
URL: <http://mail.pm.org/pipermail/dfw-pm/attachments/20140325/f15dfda6/attachment-0001.jpg>