topic Re: Perform table join with ESRI For Office in ArcGIS for SharePoint Questions

Perform table join with ESRI For Office

OlaSvensson — Thu, 12 Nov 2015 11:43:35 GMT

I'm wondering if it is possible to perform a table join in Microsoft Excel with ESRI For Office (similar to what can be done in ArcMap)? I have an Excel-table with two columns: an ID-number and a short information-string. I would like to join this table with a layer published to ArcGIS Online from ArcServer. The layer published to ArcGIS Online contains polygons with ID-numbers corresponding to those in the Excel-file (stored as attribute-values).

So, I'm able to create a "base map" in Excel, and I'm able to read the ArcGIS Online-layer to that map. But I'm uncertain where to go from here. I have tried using the add "From Excel"-tool on the map and selecting either a series of cells or the entire table and then selecting the "place type" of my imported ArcGIS Online-layer (which should work if I'm reading the documentation/help correctly), but the data-import fails consistently on every row in the excel-table.

Am I missing something here, or is this type of workflow not possible?

Re: Perform table join with ESRI For Office

KyleBalke__GISP — Thu, 12 Nov 2015 19:01:11 GMT

Ola,

Did you match up the ID number field from the hosted layer with the correct field containing the same ID in your table? This is done on the Add data dialog...click Confirm location columns and use the drop-down to select the correct field.

Re: Perform table join with ESRI For Office

JasonHinsen2 — Thu, 27 Sep 2018 20:29:04 GMT

I am having the same problem and results. When I select all the properties similarly to Ola's example, nothing shows up in the 'Current values:' or 'Expected values' examples for the field I want to join. All the other fields in the spreadsheet give a preview of the contents except for the one I'm trying to join.