twoplustwo
Registered User.
- Local time
- Today, 12:40
- Joined
- Oct 31, 2007
- Messages
- 507
Hi all, hope you're well.
I have the following data (assume each item is a column in the array) set of about 120K records:
Customer1 A B 120
Customer1 A B 100
Customer1 A C 200
Customer2 A D 150
Customer2 A D 100
Customer2 A E 100
I need to aggregate this up into the following:
Customer1 A B 220
Customer1 A B 100
Customer1 A C 200
Customer2 A D 250
Customer2 A E 100
I need to basically group by the first 3 items and sum the last column - similar to using a query.
Any ideas?
Thanks.
I have the following data (assume each item is a column in the array) set of about 120K records:
Customer1 A B 120
Customer1 A B 100
Customer1 A C 200
Customer2 A D 150
Customer2 A D 100
Customer2 A E 100
I need to aggregate this up into the following:
Customer1 A B 220
Customer1 A B 100
Customer1 A C 200
Customer2 A D 250
Customer2 A E 100
I need to basically group by the first 3 items and sum the last column - similar to using a query.
Any ideas?
Thanks.