Excel sheet join column data

745
3
08-20-2013 01:15 PM
JeffPope
New Contributor II
I have a map with 1 layer. Each polygon has a field 'FIELDFULL'. I have a spreadsheet with tabular data also with a field 'FIELDFULL'. Map comes up fine. When I try to add the Excel data it only has options for the approved list of location fields, no way to select the common column to match the data. I thought on the previous version I was able to join on that field as a custom field. Please advise on how to display the data in the spreadsheet joined on the custom column.


Jeff
0 Kudos
3 Replies
HeathBrackett1
Occasional Contributor II
I assume that you have created a custom locator that locates Excel data based on the FIELDFULL field.  But when you try to use that locator, the FIELDFULL field in your Excel data is not available?  Correct?

Are both of these fields formatted the same? (as in both as text or both as numeric?)
0 Kudos
JeffPope
New Contributor II
That is correct. both are text fields.
0 Kudos
HeathBrackett1
Occasional Contributor II
I'm not sure what is going on but I'd try a couple of things. 

Format your spreadsheet as a table.  This has been recommended to me by ESRI. 

Try changing the name of your Excel location field. 

If that doesn't work, try re-creating your custom locator. 

While this add-in is pretty slick, I've noticed a number of little inconsistencies and bugs with it.
0 Kudos