topic Iterate through list of parameterized field values in Model Builder? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/iterate-through-list-of-parameterized-field-values/m-p/153692#M5169 <HTML><HEAD></HEAD><BODY><SPAN>Hello - I know there is a way but can't figure out how to do this in Model Builder.&nbsp; Currently, my model accepts as a parameter a single feature class.&nbsp; Later there is a Select statement that uses a hard coded field name in the query section to create a new feature class, and then the rest of the model runs, generating a single output feature class.&nbsp; </SPAN><BR /><SPAN>Here is what I would like: once the user chooses the single input feature class, s/he can then create a list of different field names (based on that input feature class).&nbsp; The field names in this list are used to populate the SQL query in the Select statement (each SQL query accepts only one field name).&nbsp; The rest of the model runs once for each field name, and spits out the same number of output feature classes as there were input field names.&nbsp; I hope that makes sense.&nbsp; </SPAN><BR /><SPAN>Here is what I can't figure out:&nbsp; 1.&nbsp; How to create a variable that allows the user to create a list of fields based on the input feature class.&nbsp; 2.&nbsp; How to iterate through this list of field names, feeding them to the Select statement somehow so the rest of the model runs once per field name.&nbsp; I can't tell if I need to use an iterator here (and which type of iterator) or a parameter that accepts a list of values, and how to connect it all so it works.&nbsp; Any assistance would be of great help.&nbsp; </SPAN><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Fri, 30 Sep 2011 13:23:18 GMT JayGregory 2011-09-30T13:23:18Z Iterate through list of parameterized field values in Model Builder? https://community.esri.com/t5/geoprocessing-questions/iterate-through-list-of-parameterized-field-values/m-p/153692#M5169 <HTML><HEAD></HEAD><BODY><SPAN>Hello - I know there is a way but can't figure out how to do this in Model Builder.&nbsp; Currently, my model accepts as a parameter a single feature class.&nbsp; Later there is a Select statement that uses a hard coded field name in the query section to create a new feature class, and then the rest of the model runs, generating a single output feature class.&nbsp; </SPAN><BR /><SPAN>Here is what I would like: once the user chooses the single input feature class, s/he can then create a list of different field names (based on that input feature class).&nbsp; The field names in this list are used to populate the SQL query in the Select statement (each SQL query accepts only one field name).&nbsp; The rest of the model runs once for each field name, and spits out the same number of output feature classes as there were input field names.&nbsp; I hope that makes sense.&nbsp; </SPAN><BR /><SPAN>Here is what I can't figure out:&nbsp; 1.&nbsp; How to create a variable that allows the user to create a list of fields based on the input feature class.&nbsp; 2.&nbsp; How to iterate through this list of field names, feeding them to the Select statement somehow so the rest of the model runs once per field name.&nbsp; I can't tell if I need to use an iterator here (and which type of iterator) or a parameter that accepts a list of values, and how to connect it all so it works.&nbsp; Any assistance would be of great help.&nbsp; </SPAN><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Fri, 30 Sep 2011 13:23:18 GMT https://community.esri.com/t5/geoprocessing-questions/iterate-through-list-of-parameterized-field-values/m-p/153692#M5169 JayGregory 2011-09-30T13:23:18Z Re: Iterate through list of parameterized field values in Model Builder? https://community.esri.com/t5/geoprocessing-questions/iterate-through-list-of-parameterized-field-values/m-p/153693#M5170 <HTML><HEAD></HEAD><BODY><SPAN>Check if this </SPAN><A href="http://blogs.esri.com/Dev/blogs/geoprocessing/archive/2011/08/25/Generating-a-choice-list-from-a-field-.aspx">Blog</A><SPAN> helps with what you are trying to do. Download the script tool to generate a dynamic value list. You can use the tool as shown in the example. </SPAN><BR /><BR /><SPAN>If at all you want to output the field name as well, modify the script to have an additional derived output and set that derived output to be something like&nbsp;&nbsp;&nbsp; arcpy.SetParameter (4, InputField)</SPAN><BR /><BR /><SPAN>Then you can use both the field name and the field value in your SQL query as in-line variable substitution as shown in the blog example.</SPAN></BODY></HTML> Mon, 03 Oct 2011 16:32:17 GMT https://community.esri.com/t5/geoprocessing-questions/iterate-through-list-of-parameterized-field-values/m-p/153693#M5170 ShitijMehta 2011-10-03T16:32:17Z