AnsweredAssumed Answered

Importing Multiple Columns of XY Data from Excel File

Question asked by daniel.m.getz on Oct 17, 2019
Latest reply on Oct 18, 2019 by kelly.koenig

I have an excel file with about 200 rows. Each row has 6 columns. The first 3 columns in order are 'Distributor ID', 'Distributor Lat', and 'Distributor Long'. The next 3 columns are the same except that they're for the 'Customer ID', 'Customer Lat' and 'Customer Long'. Using the XY Table to point, I am able to access the Distributor Lat and Long, but the tool can't seem to find the Customer Lat and Long fields. Is there a tool that does this? Am I using the tool wrong? Do I just have to restructure my input table? Picture Included for reference.

Outcomes