topic Re: Model Builder tool question in ArcGIS Pro Questions

Model Builder tool question

JustinBernard1886 — Fri, 24 Sep 2021 15:59:41 GMT

Hi,

So I created a model that requires the use of 3 seperate "select by attribute." tools. For the model to run, the user must input a value into each tool seperately. I was wondering if it's possible to make it so that the user can enter the value once, and all 3 tools are automatically updated? Is it possible this can be done using Python and what would the code look like?

Thanks

Justin

Re: Model Builder tool question

curtvprice — Fri, 24 Sep 2021 23:04:30 GMT

If you can build the three expressions from one input, that can be done using the Calculate Value tool. Or you can have the three expression marked as parameters and the user can specify them and run the model.

Another approach is to create a variable and then use that variable directly in the SQL expressions for you select by attribute surrounded by % signs. The value is substituted in at runtime.

I think we need a little more detail to understand what you need, but maybe this will help you get started.

Re: Model Builder tool question

JustinBernard1886 — Wed, 06 Oct 2021 12:02:24 GMT

Apologies for the late response, I had to put this project on the backburner for a while.
Attached is a screenshot of my model. As you can see, I have two select by attribute tools in this model. For it to run, the user will have to select from 79 Areas(Called Z-Areas in my organization) in both select by attribute tools. I would to make it so that the user will only have to make one input instead of having to open each Select Layer tool and make the selection. Is this possible?

Thanks

Re: Model Builder tool question

curtvprice — Thu, 07 Oct 2021 13:56:45 GMT

Are Expression and Expression(2) different? If they are the same, you can connect the same variable to both Select Layer by Attribute tools.

Whether they are the same or different, make them parameters and run the model as a tool.

Re: Model Builder tool question

JustinBernard1886 — Fri, 08 Oct 2021 17:15:06 GMT

Oh perfect! Setting the parameters and running the model as a geoprocessing tool worked perfect.
Thanks so much for that solution!