Connect Multiple Origins to Multiple Destinations

Question

Hello,

I am a new user to ArcGIS online and am trying to better understand the origins to destinations function to better fit my use case. I am looking to connect multiple origins with multiple destinations found in 2 CSVs. CSV 1 is the origins and includes unique community names and locations, as well as a column named "School" to connect to CSV 2 that includes unique school names and locations. The part that does not seem to work for me is that the school field in the community CSV has multiple entries separated by a pipe and because of this the error message I am getting is saying the origin does not match the destination as the tool is not seeing the pipe as a delimiter but rather one large destination (ex. Holy Angels|Joussard|Lac la Biche|Grouard). I was hoping this would work with the desired output being a many to many visualization of relationships between schools and communities. I will continue to test this but if someone has any advice it would be much appreciated! I will try a smaller sample size and create multiple entries in the origin CSV (community A with a link to school A in row 1, Community A to School B in row 2, and so on) but then I do not want to create multiple points on the map for School A.

Thanks in advance!

Jesse

JesseBoiteau · Answer

Thanks, Laura! I will look into this further. At first glance it appears they are using the "Find Nearest" analysis tool, which can connect one to many based on distance up to a maximum of 100. Because my workflow is based on inherited relationships between communities and schools depending on where children came from I am not sure this will work as it is not necessarily the closest communities that relate to schools, but I will certainly play around with it.

lmott · Answer

This may be helpful too. This is not something I have personally done but the documentation says it is possible. https://community.esri.com/t5/arcgis-online-questions/many-to-many-connect-origins-to-destinations/td-p/1254825

JesseBoiteau · Answer

This did not work so I installed ArcGIS Pro to see if I can find a way to import a CSV with data representing many to many origins to destinations, or even a unique list of origins to many destinations.