What I want to do are follows :
1. First of all, the base database that I have to use is some facility points(point layer) and road network(link layer).
2. Calculate the every euclidean distances between each links and every points.
3. What I want to do finally is aggregating figures by road link id, so that making a list of "the sum of eulidean distance from each links to every single facility points".
So this is an example of middle output, which corresponds to step 2 and,
![asdfjljwg_0-1657792360539.png asdfjljwg_0-1657792360539.png](https://community.esri.com/t5/image/serverpage/image-id/45868iAB5EB5065414B92C/image-size/medium?v=v2&px=400)
this is an example of final output that I want ultimately...
![asdfjljwg_1-1657792605081.png asdfjljwg_1-1657792605081.png](https://community.esri.com/t5/image/serverpage/image-id/45869iAD7A77DB8C6B7C9D/image-size/medium?v=v2&px=400)
If there is function that can perform to final output directly, it will be best. But I'm not sure if this kind of function exists.
So if it doesn't exist, please recommend me at least a function that can make middle output so that I can aggregate figures by R or something else.
Thank you