topic Re: Model Builder Iteration in ModelBuilder Questions

Model Builder Iteration

FelixBuchinger — Mon, 15 Jan 2018 09:41:58 GMT

Hello, i'm using Modelbuilder too analyse a point feture class.

Goal is to iterate different sql expressions out of a tabel to select various features of the point feature class.

Question: is there a possibility to name the output of the selection referring the sql expression out of the iterator.

using the variable %Value% doesnt work because there a spaces in the sql expression (example: YEARS BETWEEN 0 AND 9)

is there a possibility to use for example a different column for the naming?

Currently used iterator: Iterate Field Values

Thanks for the help

Re: Model Builder Iteration

curtvprice — Sun, 12 Dec 2021 10:50:56 GMT

You may want to try the For iterator with Calculate Value tool to generate each sql expression, for example:

Calculate Value expression:

"YEARS BETWEEN {} AND {}".format(%n% * 10, ((%n% + 1) * 10) - 1)‍‍

With the For set to be 0 to 2 by 1 you'd get these expressions on each iteration, which you then would pipe into a Select Layer by Attributes or Select tool:

YEARS BETWEEN 0 AND 9
YEARS BETWEEN 10 AND 19
YEARS BETWEEN 20 AND 29‍‍‍‍‍‍‍‍‍

SQL reference for query expressions used in ArcGIS—ArcGIS Pro | ArcGIS Desktop

Examples of using iterators in ModelBuilder—Tools | ArcGIS Desktop

Re: Model Builder Iteration

FelixBuchinger — Tue, 16 Jan 2018 09:03:34 GMT

Thank you,

this is working, but not bringing the solution to the main problem.

Even with this way you can't name the output of the Select tool after an iterated input. Like Tool: Select --> Name of the output feature class: "OutputSelect_%Output_Value%" (not working because of the spaces in "YEARS BETWEEN 0 AND 9"). Using the %Value% out of the Iterator `for` doesnt make it any better because then there is only writen "0", "1" an so on... (This can be reached by putting n into the output name of the select tool: "OutputSelect_%n%")

So is there a possibility to tell the iterater so output another column of the iteration tabel?

Thanks for all the help

Re: Model Builder Iteration

curtvprice — Sun, 12 Dec 2021 10:50:59 GMT

You can use another Calculate Value tool to insert spaces as follows

"%SQL Expr%".replace(" ", "_")
‍

this would convert your expression to the string:

YEARS_BETWEEN_0_AND_9
‍

and use the created variable in your output name instead of %n%:

Re: Model Builder Iteration

FelixBuchinger — Wed, 17 Jan 2018 14:02:23 GMT

Thank you so much! That helped a lot

Regards