0

I'm new to ModelBuilder. I have created a script in python that gives results for each month, using ModelBuilder how can I make a sum between each field of each month of the year to have a single feature class with the totals. Here is a figure explains what I am looking for. enter image description here

5
  • Does the tables have geometries? Are they the same? Or do you just want a table output?
    – BERA
    Dec 18, 2021 at 18:26
  • 1
    Placing "or ArcPy" in the title makes this two questions. Since you don't actually mention ArcPy in the body, it would be better to remove the title text and tag.
    – Vince
    Dec 18, 2021 at 21:02
  • thank you for your comment BERA, Vince, yes, the tables have their geometries, they are the polygons of the buildings in a district. i have calculated their energy needs for each month, and i want to do the total for the whole year through Modelbuilder or through an Arcpy script. but i don't know how to proceed.
    – ECHLOUCHI
    Dec 18, 2021 at 22:28
  • the fields of the table of the 12 feature class are the same.
    – ECHLOUCHI
    Dec 18, 2021 at 23:22
  • Please make sure that any text you include on pictures to try and explain your question also appears as formatted text within your question body. That way it's available to searches and easily read on all devices.
    – PolyGeo
    Dec 19, 2021 at 7:00

1 Answer 1

3

If I have understood what you want, you could do this:

  1. In each table add a new field and populate it with the year, so each row in the table is the year. I see that as functionality written into your existing script.
  2. Merge all the tables into a single table
  3. Run summary statistics tool summing the fields but grouping by the year. This will generate your sums in a new table
2
  • thank you Hornbydd for your feedback ! I have tested your proposal, the tables have their geometries sorry I didn't mention it, they are the polygons of the buildings of a district. when I merge them, I get for each building 12 duplicate polygons for the 12 Months. but what I'm looking for is a single polygon of the building with the total of 12 months.
    – ECHLOUCHI
    Dec 18, 2021 at 23:15
  • Does each polygon have a building ID that is the same in each table, so for example the same building is always X. If so simply add another group by field in the summary statistics tool.
    – Hornbydd
    Dec 19, 2021 at 2:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.