RE: Use SQL to give me one record from many

Luis, Charles, Rob
MANY thanks for the replies
It WAS in fact pivot tables that I needed
As it happens, the user was satisfied with the result obtained from excel
Again - MANY thanks
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Tuesday, June 07, 2011 2:33 PM
To: Midrange Systems Technical Discussion
Subject: Re: Use SQL to give me one record from many

Alan,

As Rob said, it seems a work for pivot tables. Also, I'm quite busy at this moment, but you can find an article and utility for pivot tables here:

http://www.itjungle.com/mpo/mpo032703-story01.html

HTH,

Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--



On Tue, Jun 7, 2011 at 1:35 PM, <rob@xxxxxxxxx> wrote:

Busy, but I think what you are looking for is called a "pivot table".


Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Alan Shore <ashore@xxxxxxxx>
To: "'midrange-l@xxxxxxxxxxxx'" <midrange-l@xxxxxxxxxxxx>
Date: 06/07/2011 01:58 PM
Subject: Use SQL to give me one record from many
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Hi everyone
Here is my predicament
I have one file with 2 fields, for example
Field 1 Field 2
A 100
A 150
A 161
B 007
C 005
C 001
C 017
C 999
Etc.
I need to provide the following result in a different file
Field 1 Field 2 Field 3 Field 4 etc.
A 100 150 161
B 007
C 001 005 017
999
And so on
I am sure that I have seen some e-mails about this in the past, and I
have tried looking for them, but I am not even too sure what the
correct key words should be So - if anyone can point me in the correct
direction, as always, all responses MUCH appreciated

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.