Select By Attributes in ModelBuilder?

Discussion created by dbloch on Feb 10, 2012
Latest reply on Feb 10, 2012 by dbloch
I want to select certain features based on their attribute in one field and then calculate a new value in another field.  I know I can do this manually with the "Select By Attributes" tool in the attributes table and then calculating the values for the second field.  I want to setup a ModelBuilder to automate this so I don't have to do it manually.  Is there a way to select features in ModelBuilder without creating an output file?  Basically, I want to write a formula that says if Field1 = A, B or C, then calculate Field2 = X; if Field1 = D, E or F, then calculate Field2 = Y; etc.