Model Builder to summarize attributes on a select by attribute query

[LeilaJackson1]

Hi - I am working in Pro 3.0.1. I have a model builder that includes a select by attribute step (Subwatershed=Y), and then the next step is to summarize the attributes to provide the sum of scores (PAR) by Project ID on the selection. I would expect only the records included in the selection to be included in the summarize by attributes summary; however, the summarize by attribute process is ignoring the selection and calculating the sum on all records in the layer. The select by attribute step is working. If I do this manually, outside of model builder, it does it correctly. Does anyone have any suggestions why this is occurring? The warning on the Summarize by Attribute step is just that the table already exists.

Best,

Leila

[MZ23]

Prior to your 'select layer by attribute' tool, did you first use a 'Make Feature Layer' tool? I believe this is needed to create a layer that you can select against. https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/make-feature-layer.htm

Somebody more knowledgeable can probably speak to this better, but this was a solution for me in the past with this same issue

[LeilaJackson1 · Accepted solution]

Thanks @MZ23 -

This got me on the right track. As I was using a table, I had to use the Make Table View tool and that worked great.

Best,

Leila