topic Re: Iterate Field Values - Using Value in Select Layer By Attribute in Geoprocessing Questions

Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Fri, 12 Apr 2013 14:21:59 GMT

I am trying to build a model that iterates through the unique values of a field, then selects each of those values and calculates another field for that selection. I'm having trouble passing the Value output from the iteration to the Select Layer by attribute tool. For example each iteration would output a unique number, lets say 2104, then the Select Layer by Attribute tool would use 2104 as the selection criteria. The model would iterate through all of the unique values calculating the field for each selected set. I can't figure out how to get the Select Layer by attribute to use the output Value of the iteration. Any help would be appreciated. I am very new to model builder.

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Fri, 12 Apr 2013 16:36:30 GMT

BJ,

Take a look at how the attached model is set up. I set the input layer as input to both the Iterate Field Values iterator and the Select Layer by Attribute tool. I used the Value output from the iterator as part of the expression in the Select Layer by Attribute tool.

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Fri, 12 Apr 2013 18:38:15 GMT

Matt,

Thanks for your help on this. I am still having an issue. How can I get the Expression for the Select Layer By Attribute to pull in the Value output from the Iterate Field Values? The expression needs to be something like FieldName = Value for each iteration.

Thanks

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Fri, 12 Apr 2013 19:15:54 GMT

I used "GridNumber" = %Value% but it does not select anything.

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Fri, 12 Apr 2013 22:22:18 GMT

"GridNumber" = %Value% is correct. That is what worked on my end with my data. What is the field type of GridNumber? I used a short integer field. Also, what is the 'Data Type (optional)' set to inside the Iterate Field Values parameter window? Mine is set to String.

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Fri, 12 Apr 2013 22:25:26 GMT

Also, feel free to attached your current model and input data file. I can take a look at it for you.

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Mon, 15 Apr 2013 13:21:22 GMT

I think I have everything set as you have described, however I'm still not getting a good result. I have attached the model and the data if you wouldn't mind taking a look. Thanks

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Mon, 15 Apr 2013 14:45:00 GMT

I was able to get this to successfully run on my end with a basic field calculation. The issue seems to be within your code block possibly, I'll take a look. What is the outcome you are expecting to see?

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Mon, 15 Apr 2013 15:02:53 GMT

For all features with a "GridNumber" that is the same, the "FeatureNumber" field would be get an incremental value of 1 through n. For example if 5 features have a "GridNumber" = 3105, then "FeatureNumber" would be 1, 2, 3, 4, and 5.

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Mon, 15 Apr 2013 15:18:43 GMT

In the Calculate Field tool, try changing the Expression Type to PYTHON_9.3. This change allowed the model to run successfully on my end with your exact code block.

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Mon, 15 Apr 2013 15:33:24 GMT

When I run the model it doesn't seem to get past the first iteration. It looks like Value = 1 instead of a the first value from the GridNumber field.

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Tue, 16 Apr 2013 23:10:20 GMT

Not sure what may be going on. I have attached a model and shapefile that works correctly on my end. See if you can successfully run it as well on your end.

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Wed, 17 Apr 2013 17:44:50 GMT

Matt,

I can't see a model inside of toolbox1.

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Fri, 19 Apr 2013 13:03:48 GMT

Matt,

Can you please reattach the toolbox with the model?

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Fri, 19 Apr 2013 13:07:11 GMT

What version of ArcGIS for Desktop are you utilizing?

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Fri, 19 Apr 2013 13:17:16 GMT

I have tried on 10.0 and 10.1.

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Fri, 19 Apr 2013 13:29:01 GMT

Try this one. Be sure to extract the contents from the zip folder first.

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Fri, 19 Apr 2013 13:43:36 GMT

I must be missing something. When I add your toolbox, there doesn't seem to be anything in it.

Re: Iterate Field Values - Using Value in Select Layer By Attribute

MatthewPayne — Fri, 19 Apr 2013 14:24:42 GMT

I had a few of my collegues attempt to open the model and they were successful. I am not sure what may be going on. Confirm that you are taking the exact same steps as entailed in the .swf video file below.

Matt

Re: Iterate Field Values - Using Value in Select Layer By Attribute

BJMalone — Fri, 19 Apr 2013 15:32:32 GMT

Matt,

I cannot see the model inside the toolbox in version 10.0. However, I moved to a 10.1 machine and can access it. I ran the model exactly as you have it with the point3 file and it worked as expected. I replaced your point3 file with my file and reran the model and it is currently running through all the iterations. It may take it awhile to complete, but I will let you know the results when it's complete. Thanks for you help on this. I'm beginning to think something in my 10.0 installation was the problem.

BTW are you the same Matt Payne from WKU?