nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Model Builder Iteration

FelixBuchinger

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

Encuentra más publicaciones etiquetadas con

Accepted answers

curtvprice

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

<SPAN class="string token">"%SQL Expr%"</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"_"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

this would convert your expression to the string:

YEARS_BETWEEN_0_AND_9
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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

All comments

FelixBuchinger

Thank you so much! That helped a lot

Regards

curtvprice

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

<SPAN class="string token">"%SQL Expr%"</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"_"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

this would convert your expression to the string:

YEARS_BETWEEN_0_AND_9
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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

FelixBuchinger

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

curtvprice

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

Calculate Value expression:

<SPAN class="string token">"YEARS BETWEEN {} AND {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">%</SPAN>n<SPAN class="operator token">%</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="operator token">%</SPAN>n<SPAN class="operator token">%</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

Examples of using iterators in ModelBuilder—Tools | ArcGIS Desktop

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.