topic Re: SQL query in Modelbuilder? in ModelBuilder Questions https://community.esri.com/t5/modelbuilder-questions/sql-query-in-modelbuilder/m-p/764764#M2944 <HTML><HEAD></HEAD><BODY><P>Try </P><P>1. Adding <A href="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/make-feature-layer.htm" title="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/make-feature-layer.htm">Make Feature Layer—Help | ArcGIS for Desktop</A>​ . Connect the iterated shapefile to this tool, and connect the output layer to Select layer by attribute.</P><P>2. Also add <A href="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/copy-features.htm" title="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/copy-features.htm">Copy Features—Help | ArcGIS for Desktop</A>​ to the end of the model if you want the selected features in separate shapefiles. </P></BODY></HTML> Sun, 31 Jul 2016 23:18:40 GMT JayantaPoddar 2016-07-31T23:18:40Z SQL query in Modelbuilder? https://community.esri.com/t5/modelbuilder-questions/sql-query-in-modelbuilder/m-p/764763#M2943 <HTML><HEAD></HEAD><BODY><P>Hi! </P><P>I'm trying to apply a definition query to a bunch of shapefiles&nbsp; (100s) in the same directory. </P><P>Been trying but can't get the Iterator to connect to the tool Select Layer by Attribute where I'm able to execute the query. </P><P>This has been my approach so far: </P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/213942_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Have any ideas or know if I'm on the right path at least? </P><P>Cheers!</P></BODY></HTML> Fri, 29 Jul 2016 22:59:41 GMT https://community.esri.com/t5/modelbuilder-questions/sql-query-in-modelbuilder/m-p/764763#M2943 HectorBorro1 2016-07-29T22:59:41Z Re: SQL query in Modelbuilder? https://community.esri.com/t5/modelbuilder-questions/sql-query-in-modelbuilder/m-p/764764#M2944 <HTML><HEAD></HEAD><BODY><P>Try </P><P>1. Adding <A href="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/make-feature-layer.htm" title="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/make-feature-layer.htm">Make Feature Layer—Help | ArcGIS for Desktop</A>​ . Connect the iterated shapefile to this tool, and connect the output layer to Select layer by attribute.</P><P>2. Also add <A href="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/copy-features.htm" title="http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/copy-features.htm">Copy Features—Help | ArcGIS for Desktop</A>​ to the end of the model if you want the selected features in separate shapefiles. </P></BODY></HTML> Sun, 31 Jul 2016 23:18:40 GMT https://community.esri.com/t5/modelbuilder-questions/sql-query-in-modelbuilder/m-p/764764#M2944 JayantaPoddar 2016-07-31T23:18:40Z Re: SQL query in Modelbuilder? https://community.esri.com/t5/modelbuilder-questions/sql-query-in-modelbuilder/m-p/764765#M2945 <HTML><HEAD></HEAD><BODY><P>Will look into it, thanks!</P></BODY></HTML> Mon, 01 Aug 2016 14:29:19 GMT https://community.esri.com/t5/modelbuilder-questions/sql-query-in-modelbuilder/m-p/764765#M2945 HectorBorro1 2016-08-01T14:29:19Z