I have two polyline layers with corresponding attributes. Each layer has 100,000+ rows. I need to calculate the distance between the corresponding features from each layer.
E.g.
Layer 1:
FID | LineID
1 1234
2 5678
3 9012
Layer 2:
FID | LineID
1 9012
2 1234
3 5678
I need to find the distance between the rows from each layer that match by LineID.
ESRI had a blog about using model builder to create a Near By Group tool - https://blogs.esri.com/esri/arcgis/2010/09/16/nearbygroup/
The tool seems to stall out (probably because of the large number of rows). Does anyone have any other ideas on how I can accomplish this task?