AnsweredAssumed Answered

ModelBuilder: How to input specific area values of multiple new shapefiles (39) into a table to Excel

Question asked by tiffatiger on Oct 8, 2018
Latest reply on Dec 19, 2018 by JSimms-esristaff

Hello everyone! I am new to this community but have found a lot of the answers extremely helpful.

I've created a main model on ArcGIS Desktop with five submodels nested in it. I'm on my final step and hoping this is possible to minimize the manual labor in doing my project.


So, I start off with a bunch of country shapefiles (i.e. India, China, Bangladesh, etc.) and I clip them based on a 0/1 binarization. Then I separate them into two different folders and clip them with another shapefile input. Then, for all the new shapefiles created (I believe there's 39 total), I iterate a process where it creates an Area field and calculates the Area for each by using 'Calculate Geometry'.


Now, I would like to put all these tables together for each table, listing specifically: Shapefile Name and Area in KM. Then, the attribute table would ideally look something like this. 

... and so forth. Is this possible to do in ArcGIS?


Then, after there's a separate table for all of the shapefiles and their areas, I would like to export that exact table to Excel. I know that that's probably the easier part, but I'm wondering how I can nicely organize the areas with each shapefile before putting it into Excel, to minimize manual work.


Please let me know if there are any solutions. I would love to answer any clarification questions if needed.