AnsweredAssumed Answered

Consolidating Records

Question asked by DaleConrad on Mar 19, 2009
Latest reply on Mar 19, 2009 by philmodjunk

Title

Consolidating Records

Post

After importing records from an excel spreadsheet, I need to consolidate records which have the same unique ID.  In this case, "consolidate" means ending up with one record (from 2 or more with the same Unique ID) wherein the consolidated record's fields, where applicable, would be the sum of the same fields from the individual records.  

 

For example, starting out with this record layout:

 

Unique ID/Value1/Value2/Value3

D1/25/35/45

D1/35/45/55

D2/20/30/40

 

...would be processed to ultimately end-up with a record set like this:

 

D1/60/80/100

D2/20/30/40

 

How can this be done? 

 

Outcomes