AnsweredAssumed Answered

How do I combine 3 records into 1 in an attribute table and sum the lengths of those 3 records in the new record

Question asked by courtneylwade2017 on May 6, 2018
Latest reply on May 6, 2018 by Dan_Patterson

I am using ArcGIS Pro and I am working with road data where the road is divided into segments. Each segment is listed as individual records in the attribute table. For example, there are 3 records (segments) for RoadNumber 1003. Not only am I wanting to join the 3 segments into 1 record withing the original attribute table, I am also wanting the field ‘seglength’ of the combined record to give the sum of the 3 segments. Is this possible and if so, would you please explain the steps to achieve these resulrts? I greatly appreciate it. 

 This is the screenshot of the table:

 

This is what I was hoping to do (I'm nor sure what happens in the final two columns)

Outcomes