New answers tagged select-by-attribute
[Posted earlier as an "edit" to my own question. Per Sorin's advice, I'm changing this to an answer instead of an edit.] I think I may have solved it. I used a percent sign ( % ) as a "wild card" along with the LIKE operator, and it looks like I got the expected search results. Example 1: In a roads shapefile layer, "FULLNAME" LIKE '%68%' produced a ...
You can also use the column filter of the attribute table. It works default as a 'like' expression without the % wild card. Result when typing a:
Based on the discussion in the comments, what was actually being asked for was an easier way to select just one column to be retained in the output feature layer. The Make Feature Layer tool can do this via the 'Field Info' parameter, which presents you with a list of checkboxes (all checked by default) representing all of the fields which will be visible in ...
You could try doing this: http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=1090&pid=1088&topicname=Select_%28Analysis%29 You could also try http://help.arcgis.com/en/arcgisdesktop/10.0/help../index.html#//001700000071000000 lastly you could create a script and save to a button to run.
From what you have described in comments, and your added screenshots, I think that you want to just pull a single field through from your original feature class (with many fields) to make a new feature class with just that one field. There is a technique described in How to re-order fields permanently using ArcGIS Make Query Table tool? that I believe will ...
I'm not sure if I understand your question correctly, but I think what you're asking is you just want a SQL query to use in Select by Attribute GP Tool's expression field; and you want this SQL query to always select all of the records in the table/feature class. If so, why don't you just use a SQL expression along the lines of OBJECTID > -1 That ...
Try selecting OBJECTID > 0. OBJECTID being your Object Identifier field, of course.
At this point, the problem with your where clause is that it will be interpreted as (assuming FID = 1 what you should have is "FID" = 1 (or [FID] with personnal geodatabase), therefore the python command need to be ' "FID" = ' + str(row) Remark : It is a bit strange to create a layer inside a cursor, especially with FID's which are ranked suites of ...
Top 50 recent answers are included