Displaying records per contract and associated amounts

madishpa · New User Joined: 18 May 2007 Posts: 28 Location: Hyderabad

Hi,

I have a requirement where some contracts have associated amounts and the maximum number of occurences per contract are 20.
I will have to reproduce the report where the contract number is followed by the amounts. Can you please advise if this achieved using Sort.

Sample Input Records:

Contract1 10.00
Contract1 10.00
Contract1 20.00
Contract2 12.00
Contract3 5.00
Contract3 5.10
Contract3 5.01
Contract3 11.00
Contract3 25.00

Output:

Contract1 10.00 10.00 20.00
Contract2 12.00
Contract3 5.00 5.10 5.01 11.00 25.00

Thanks,
Madishpa

Bill Woodger · Posted: Mon Feb 16, 2015 8:30 pm

You can look at this one.

It would be easy in language which has "arrays", but SORT doesn't have them.

madishpa · New User Joined: 18 May 2007 Posts: 28 Location: Hyderabad

Thanks Bill