topic Re: How can I include 'All' in a Variable Picklist in ModelBuilder Questions

How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Mon, 28 Oct 2019 19:10:39 GMT

I am building a tool using model builder in ArcGIS pro. I will like the user to be to select all in my variable pick-list;for instance i want the user to select all location (polygon).

Re: How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Tue, 29 Oct 2019 13:23:47 GMT

Please I need a urgent response or the question is not clear enough? I can explain further.

Re: How can I include 'All' in a Variable Picklist

Anonymous User — Tue, 29 Oct 2019 17:27:47 GMT

A little more detail about what your model is doing could be helpful, but one way you could go about this is using a "Logical" operator:

to test the input value. If the value equals a value of your choice, representing 'all' (for example "All Sites"), then that branch would use a selection expression that selects all sites. If not, the expression will select whatever site is selected from the pick list.

Here is a very quick example:

and then the expression would use the variable if the user selected something other than the "all" value, for example:

Re: How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Tue, 29 Oct 2019 17:41:55 GMT

Thanks for the reply,my model wants to know the population of birds in a single location which I have done, then I want to further let user to know the number of birds in all location, for instance what is the population of a bird in all location. Now in the dropdown list (sitename), where you have single location, I want to include picklist "ALL" to select all location.

Re: How can I include 'All' in a Variable Picklist

Anonymous User — Tue, 29 Oct 2019 20:21:12 GMT

If you are manually supplying the values for the pick list using the parameter properties, then you can add a value such as "ALL", for example:

and then if the user chooses that option, use a branch of the model to execute a SQL statement that selects all records. For example, this expression would select all sites:

You can test whether the user chooses that option with a logical operator, which I see you already have in your model.

If you are familiar with Python, you might consider that as another option. Typically I find Python easier to work with when a model starts using lots of conditional logic.

Re: How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Tue, 29 Oct 2019 21:01:19 GMT

Thanks for the response I will test this, And get back.

Re: How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Tue, 29 Oct 2019 23:10:13 GMT

sorry it did not work..I guess I don't understand what you explained. Can you explain further.. For instance I am building a tools that will select all polygon using modelbuilder..How can I include ' all' option for user. for example, i am building this from the scratch:

Re: How can I include 'All' in a Variable Picklist

Anonymous User — Wed, 30 Oct 2019 16:38:20 GMT

Sure, here is another example that I think is a bit closer to your situation.

This model simply selects a country from a polygon layer and calculates summary statistics using the selection:

I added a "Country" variable and made it a model parameter.

The key thing is then to go into the model properties (right-click the model in the toolbox and click Properties) and enter the values that you want to appear in the pick list. I entered in some country names as well as "ALL COUNTRIES":

This creates the pick list when the tool is opened in the Geoprocessing pane:

In the model, we can then test whether the user has selected ALL COUNTRIES from the pick list:

If True, that means that the user selected "ALL COUNTRIES", and we use the Select by Attribute tool to select all polygons:

If False, that means that they selected a country name, and then we use the name of the country in the SQL expression, using the Country variable:

Preconditions are used in the model to determine which Select by Attribute tool gets executed.

I attached the example toolbox here, hopefully it will be useful.

Re: How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Wed, 30 Oct 2019 22:36:51 GMT

Thanks for your help. One more question..what is the "Values" doing there...is it a shapefile of country aside the country parameter or what, and is it also included in condition if value.

Re: How can I include 'All' in a Variable Picklist

Anonymous User — Thu, 31 Oct 2019 15:35:36 GMT

The "Values" variable contains the value to test against to see if the condition is true or false. You can test against multiple values, but in this case, we just care if the user chose the "ALL COUNTRIES" value or not.

So the string that you type in to this variable should be exactly the same as the one you type in to the parameter properties when you are specifying the values that will appear in the drop-down. You can type your value (for example, "ALL COUNTRIES") directly into the "If Value Is" tool, and it will create this "Values" variable for you (at least it did in my case).

Re: How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Fri, 01 Nov 2019 12:55:18 GMT

Hello Andrew, your tips have helped a lot but this is the problem now, whenever the location is empty it works but whenever i input "All locations" it gives warning - -'The process did not execute because the precondition is false', Is there anything wrong with my model or logic. Please help me to check it up.

Re: How can I include 'All' in a Variable Picklist

Anonymous User — Mon, 04 Nov 2019 16:02:23 GMT

This warning does not necessarily mean anything is wrong with the model -- it just means certain tools did not run, which is expected in some cases (for example, if you have a selection query for when the user chooses "All locations", and another query for when they choose another value, only one query should run, not both).

Re: How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Wed, 06 Nov 2019 20:36:47 GMT

Thanks. it is working but the only warning I get now is " All input are current". which does not allow execution of final results..What could be the reason for " All input are current".

Re: How can I include 'All' in a Variable Picklist

AyokunleAdebisi — Wed, 06 Nov 2019 20:39:57 GMT

.Thanks. it is working but the only warning I get now is " All input are not current". which does not allow execution of final results..What could be the reason for " All input are not current"