I've got a vector dataset (in fact, OS MasterMap data) and I want to set the value of a certain field based on the value of another field. For example:
Field1 Field2 Building 20 Grass 50 Water 19
In the above, I want to set the value of Field2 based on the value in Field1, that is - all records that have Building in Field1 should have Field2 set to the value of 20.
I know I can do this by doing Select by Attribute and then using the Field Calculator to give the selected records a value, but doing this loads of times is going to get very boring.
Is there a way to give ArcGIS Desktop a sort of table of values like you do in the Raster Reclass tool, and get it to do it automatically?