topic Re: Modelbuilder help in ModelBuilder Questions https://community.esri.com/t5/modelbuilder-questions/modelbuilder-help/m-p/800977#M3066 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">[ATTACH=CONFIG]30689[/ATTACH]<BR /><BR />The green triangles represent locations of mutual&nbsp; funds, which can dozens (or hundreds) of stocks. <BR /><BR />The&nbsp; NEAR tool allows me to find the distance between a specific mutual fund&nbsp; (e.g. "CHICKASAW CAPITAL MGMT") and each stock (e.g. BUCKEYE PARTNERS LP, CROSSTEX ENERGY INC, etc).<BR /><BR />Since I have 226 mutual funds for which I need to locate their stocks, how can I do this in Modelbuilder? If I do this in ArcMap, I first must use Select by Attribute for Fund_Families ("F_FAMILY" = 'CHICKASAW CAPITAL MGMT'), and must do the same for Stocks layer. Then, I can use the NEAR tool.<BR /><BR />But I don't want to have to do this 226 times. I just don't know Modelbuilder well enough to figure it all out. I appreciate any help!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>I think that you could do this by iterating through the records.&nbsp; Select the features that you would like to run the near tool on and export.&nbsp; Then, in Model Builder, iterate (loop) through each of these exported records using the ObjectID field with increments of one.&nbsp; See here:&nbsp; </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00400000001n000000">http://resources.arcgis.com/en/help/main/10.1/index.html#//00400000001n000000</A><SPAN>.</SPAN></BODY></HTML> Tue, 11 Feb 2014 13:13:02 GMT WesleyAskew 2014-02-11T13:13:02Z Modelbuilder help https://community.esri.com/t5/modelbuilder-questions/modelbuilder-help/m-p/800976#M3065 <HTML><HEAD></HEAD><BODY><SPAN>[ATTACH=CONFIG]30689[/ATTACH]</SPAN><BR /><BR /><SPAN>The green triangles represent locations of mutual&nbsp; funds, which can dozens (or hundreds) of stocks. </SPAN><BR /><BR /><SPAN>The&nbsp; NEAR tool allows me to find the distance between a specific mutual fund&nbsp; (e.g. "CHICKASAW CAPITAL MGMT") and each stock (e.g. BUCKEYE PARTNERS LP, CROSSTEX ENERGY INC, etc).</SPAN><BR /><BR /><SPAN>Since I have 226 mutual funds for which I need to locate their stocks, how can I do this in Modelbuilder? If I do this in ArcMap, I first must use Select by Attribute for Fund_Families ("F_FAMILY" = 'CHICKASAW CAPITAL MGMT'), and must do the same for Stocks layer. Then, I can use the NEAR tool.</SPAN><BR /><BR /><SPAN>But I don't want to have to do this 226 times. I just don't know Modelbuilder well enough to figure it all out. I appreciate any help!</SPAN></BODY></HTML> Wed, 22 Jan 2014 01:19:40 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-help/m-p/800976#M3065 MarkMcPherson1 2014-01-22T01:19:40Z Re: Modelbuilder help https://community.esri.com/t5/modelbuilder-questions/modelbuilder-help/m-p/800977#M3066 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">[ATTACH=CONFIG]30689[/ATTACH]<BR /><BR />The green triangles represent locations of mutual&nbsp; funds, which can dozens (or hundreds) of stocks. <BR /><BR />The&nbsp; NEAR tool allows me to find the distance between a specific mutual fund&nbsp; (e.g. "CHICKASAW CAPITAL MGMT") and each stock (e.g. BUCKEYE PARTNERS LP, CROSSTEX ENERGY INC, etc).<BR /><BR />Since I have 226 mutual funds for which I need to locate their stocks, how can I do this in Modelbuilder? If I do this in ArcMap, I first must use Select by Attribute for Fund_Families ("F_FAMILY" = 'CHICKASAW CAPITAL MGMT'), and must do the same for Stocks layer. Then, I can use the NEAR tool.<BR /><BR />But I don't want to have to do this 226 times. I just don't know Modelbuilder well enough to figure it all out. I appreciate any help!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>I think that you could do this by iterating through the records.&nbsp; Select the features that you would like to run the near tool on and export.&nbsp; Then, in Model Builder, iterate (loop) through each of these exported records using the ObjectID field with increments of one.&nbsp; See here:&nbsp; </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00400000001n000000">http://resources.arcgis.com/en/help/main/10.1/index.html#//00400000001n000000</A><SPAN>.</SPAN></BODY></HTML> Tue, 11 Feb 2014 13:13:02 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-help/m-p/800977#M3066 WesleyAskew 2014-02-11T13:13:02Z