deanster2u

Merge records into one line per year in portal

Discussion created by deanster2u on Aug 24, 2017
Latest reply on Aug 25, 2017 by deanster2u

I have a table (AnnualInfo) that tracks several different measurements that are recorded annually but not necessarily at the same time. The table has an ID field, a year field, a weight field, a color field and a length field. So a table view of the records may loo like this:

 

IDYearWeightColorLength
92015350
92015red
9201572
92014275
92014blue

 

I want a portal that will return all the items on one line per year. So the portal table results would look like this:

 

ID

YearWeightColorLength
92015350red72
92014275blue

I can't figure out how to sum up all the records on one line per year. Assistance greatly appreciated!

Outcomes