I am doing a project where I need to create a flow map in ArcMap 10.4.1.
I have imported the data from an Excel spreadsheet that I put together. The problem I am having is that when I Create A Feature Class from XY data, it only allows me to input one set of XY data. I have two sets of XY data in the spreadsheet (SiteUTMs and SourceUTMs), and need both in order to create the flow map. I cannot figure out how to get Arc to recognize the other set of XY data as coordinates to be an option in the dropdown menu in the XY to a Line tool. I tried reordering the columns in the spreadsheet to have the second set of XY data to be first in the spreadsheet, but Arc still only recognized the first set of XY data (the SiteUTMs), not the ones that I needed to add (the SourceUTMs.
I do have two other layers (one point and one polygon) that contain the information of the other XY data I need (the SouceUTMs), but there are two issues I am having with that. First, I cannot get Arc to join the layers and attribute tables with a join or relate. Secondly, in the XY to a Line tool, it only lets you input one layer source, so I cannot input both layers into the tool to have both sets of XY data that the flow lines need.