topic Re: How can i join multiple excel data for every single Polygon? in Data Management Questions

How can i join multiple excel data for every single Polygon?

FurkanGenişyürek — Mon, 15 Mar 2021 15:20:35 GMT

Hello. The problem is; there is too much data for a single polygon. I have 55 polygon and nearly 950 Excel data. I cant directly join Excel. Because, Polygon's Attribute Table just showing one data for every single polygon. I tried that; "Make Query Table" tool. Thanks to it, I can combine excel data and polygon data as a table. But i cant join it. I want analyst this excel data. I tryed edit .dbf file, but Arcgis has an error and not opened it. How can i join it to shpfile?

Re: How can i join multiple excel data for every single Polygon?

DavidPike — Mon, 15 Mar 2021 16:11:04 GMT

Are you doing a spatial join or attribute join? also by '950 excel data' do you mean 950 entries/rows or 950 individual spreadsheets?

Please provide detail, at the moment your post is just confusing and poorly explained.

Re: How can i join multiple excel data for every single Polygon?

JoeBorgione — Mon, 15 Mar 2021 19:52:09 GMT

My first suggestion is that you use the excel to table tool to convert your spreadsheet into a database table. It is much easier to work with ArcGIS tables rather than excel spreadsheets.

I can only assume you have a valid key field between the polygons and your excel data. With as many rows as your excel data seems to have, a join may not work. Joins in ArcGIS are 1 to 1 or Many to 1, but not 1 to Many. If you have 1 polygon and many records in the excel data, you will need to use a relate rather than a join.

Re: How can i join multiple excel data for every single Polygon?

FurkanGenişyürek — Mon, 15 Mar 2021 20:09:04 GMT

Thanks to reply. I did excel to table with "Make Query Table" tool. But i cant using it table for spatial analyst.

Re: How can i join multiple excel data for every single Polygon?

JoeBorgione — Mon, 15 Mar 2021 20:14:51 GMT

That is not the tool to use: see the online help linked in my post above. All that step does is take the excel spread sheet and convert it into an ArcGIS data table. You will be limited in your analytical approaches if you are using shapefles and converting the excel spreadsheet into a .dbf table. I strongly urge you to use a File Geodatabse in which to store your data, both spatial and tablular.

Re: How can i join multiple excel data for every single Polygon?

FurkanGenişyürek — Tue, 16 Mar 2021 11:29:24 GMT

This gave an Error. I wanna just spatial analyst with data.. Apparently there is no such thing in ArcGIS. Thank you..

Re: How can i join multiple excel data for every single Polygon?

JoeBorgione — Tue, 16 Mar 2021 14:13:45 GMT

Check your field names; be sure they don't start with a number and/or have special characters in them.

Well.... I've been using ESRI products since 1990 and have always been able to perform spatial analyses with all of them.