I am working on a gas service layer where we have multiple line features for one service. I now need to report how many services contain each material. The problem is we have mixed material services. So I need to report the material of the segment with the longest length within that service. Does anyone know how I could do a weighted join or dissolve/unsplit like this?