topic Re: Excel sheet join column data in ArcGIS for SharePoint Questions

Excel sheet join column data

JeffPope — Tue, 20 Aug 2013 20:15:05 GMT

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

Re: Excel sheet join column data

HeathBrackett1 — Thu, 22 Aug 2013 16:24:53 GMT

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?)

Re: Excel sheet join column data

JeffPope — Thu, 22 Aug 2013 16:36:19 GMT

That is correct. both are text fields.

Re: Excel sheet join column data

HeathBrackett1 — Thu, 22 Aug 2013 16:49:43 GMT

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.