I hope I get the terminilogy right! Correct me if I mess something up. I need to perform some calculations for a scoring system for different habitat types. The Problem is that I have two different tables in two different shapefiles. They need to be divided through each others somehow (yet again, all needs to be done automatically in the modelbuilder).
For the calculation I need to Sum up the
Size of all the
Types with a common/matching
Table A (I tried to clarify this through the field
Shapefile A with Table A Name Type Size Sum A BO 10 ? A BE 20 ? C BA 30 ? D BO 10 ? D FW 50 ?
Name A would be
30 (10+20), for
D it would be `60 (50+10).
In my second table, I do need not to do any calculations. It looks likes this:
Shapefile B with Table B Name Type Size A BO 20 A BE 50 C BA 60 D BO 90 D FW 10
I know the
Size of each
Type in in each
Table B needs to be divided through the
Sum of all the
Types for each
I hope you can see the problem I am running in. How do I tell the Modelbuilder to summarize all the
Size of all
Types that have a matching
Name? And how would I populate
Fields with this outcome for further calculations?