I'm still very new to ModelBuilder and I'm trying to work my way through it. I am trying to take a value from a table and basically paste it into a field of a feature class using ModelBuilder. I have a polygon layer that has building footprints and another polygon layer that is squares for flooding depth. These two layers can not be joined.
I currently have the model set up to select 1 building at a time and then use that building to select by location via intersect on the flood layer. This then selects anywhere between 1 and 6 flood squares. I then have to take the average of the flood depth from those squares and add it to an existing field in the building layer. This is the part I get stuck on. I can run a summary statistics to get the average of the selected flood square which creates another table.
How would I get that value into a field in the building footprint layer?
If the calculate field could accept multiple inputs this would be simple but I am having a hard time taking the data from one table and filling a field in a different shapefile.