I am having trouble finding the right words to describe this problem but here goes:
I have 3 values (120,270,380) in my field called operatingvolt for every segment of conductor. Each segment of conductor has a feederid to identify what system it belongs to. I would like to use ArcGIS to calculate the length of each segment by operatingvolt and feederid.The goal is to get a table that looks like this:
The problem I run into is that if the feederid does not have an operatingvolt then the length will not be computed. This happens frequently since not every feederid has every operatingvolt value. I would like a length computed for every feederid at every possible operatingvolt even if the length is 0.
I also would like to be able to create a model that completes this task. I have limited knowledge of python.