0

I am using ModelBuilder and would like to delete specific rows of a feature where the value of two columns are equal.

For instance: if there are columns a,b,c,d and rows 1,2,3,4. I would like to delete the rows where a=c. For that, it is first needed to select those features. When I enter the syntax in the query builder a = c I receive error (000229) and it does't work. I have tried another selection method (Make feature Layer, Selection by Attribute) I am using ArcGIS Desktop 10.2.

enter image description here

  • Rather than deleting features I think you will find it much easier to just use the Select tool to create a new feature class with only the features that you did not want to delete i.e. those where a <> c. – PolyGeo Jan 24 '17 at 10:15
  • Thank you for the feedbcak. I have tried that approach but it does not work. It can not recognise when I say a = c. I recieve error 000229 which means can not open the feature. I am assuming for defining the columns we have to úse sth else but I am not sure how. – user2355306 Jan 24 '17 at 10:41
  • My question is abit different as I donot define specific value in the column but I ask all the rows where to value of the columns of them are equal. – user2355306 Jan 24 '17 at 10:44
  • I just tested and it worked for me. I recommend editing your question to show exactly how you tried to run the Select tool. Make sure that you use the expression builder to get the syntax correct. My expression with shapefiles was "Field1" <> "Field2". – PolyGeo Jan 24 '17 at 11:06
  • 1
    Is your background processing turned on? "When background processing is turned on, scripts execute using 64-bit background processing. ArcMap is unable to read data types not supported by 64-bit background processing, while tools incapable of running in the background cannot leverage 64-bit processing. By default, ArcMap and ArcCatalog communicate through a 32-bit client library." support.esri.com/technical-article/000012177 – artwork21 Jan 24 '17 at 16:21
1

As my comment noted, "When background processing is turned on, scripts execute using 64-bit background processing. ArcMap is unable to read data types not supported by 64-bit background processing, while tools incapable of running in the background cannot leverage 64-bit processing. By default, ArcMap and ArcCatalog communicate through a 32-bit client library."

support.esri.com/technical-article/000012177

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.