View previous topic :: View next topic
|
Author |
Message |
subratarec
Active User
Joined: 22 Dec 2007 Posts: 126 Location: Bangalore
|
|
|
|
Hi,
I have a requirement (desc given below).
Code: |
MODEL COLOR SIZE QTY WAREHOUSE
AAAAA A 001 50 10
AAAAA A 001 21 09
AAAAA A 001 23 18
BBBBB B 005 26 12
BBBBB B 005 56 23
BBBBB B 005 08 04
BBBBB B 005 54 11 |
Now after SORT the SORTOUT file should contain something like this..
Code: |
MODEL COLOR SIZE QTY WAREHOUSE
AAAAA A 001 94 37
BBBBB B 005 144 50 |
Could someone plz help me on how shall I achieve this result using SORT/ICETOOL..?
Thanks in advance |
|
Back to top |
|
|
David Robinson
Active User
Joined: 21 Dec 2011 Posts: 199 Location: UK
|
|
|
|
What have you tried so far and what problems are you getting? |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You can do it with either SORT or ICETOOL. Use the OUTFIL reporting functions for SORT (like HEADER1, SECTIONS with TRAILER3) or ICETOOL's DISPLAY operator. |
|
Back to top |
|
|
subratarec
Active User
Joined: 22 Dec 2007 Posts: 126 Location: Bangalore
|
|
|
|
Hi Bill,
Thanks!! again for your help. Yes I going through the details of those options you have mentioned in reply. Hopefully I will be able to achieve the desired result. Will come back if I face any issue while coding..
Thanks |
|
Back to top |
|
|
|