https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-fill-in-list-of-values-from-excel/m-p/1273958#M67431 <P>Hi all,</P><P>I'm trying to find a way that I can import a list of values that I have in an excel file into a "List of Values" string variable in my model? I'm trying to avoid having to type each one in manually.</P> Fri, 31 Mar 2023 04:29:53 GMT slgissolutions 2023-03-31T04:29:53Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-fill-in-list-of-values-from-excel/m-p/1273958#M67431 <P>Hi all,</P><P>I'm trying to find a way that I can import a list of values that I have in an excel file into a "List of Values" string variable in my model? I'm trying to avoid having to type each one in manually.</P> Fri, 31 Mar 2023 04:29:53 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-fill-in-list-of-values-from-excel/m-p/1273958#M67431 slgissolutions 2023-03-31T04:29:53Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-fill-in-list-of-values-from-excel/m-p/1274145#M67458 <P>Use "Excel to Table" to load the data into a table, then "Calculate Value" with some Python cursors to join the column values into one big string. Something like this for the code block:</P><P>&nbsp;</P><LI-CODE lang="python">def get_list(table): return ";".join(str(x[0]) for x in arcpy.da.SearchCursor(table, "My_Field_Name"))</LI-CODE><P>&nbsp;</P><P>and then you can call the function like <EM>get_list("%output_table%")</EM>, replacing the variable with whatever the name of your output table is in modelbuilder.</P> Fri, 31 Mar 2023 15:59:41 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-fill-in-list-of-values-from-excel/m-p/1274145#M67458 DavidSolari 2023-03-31T15:59:41Z