I'd like to assign a new name (either HIGH, MEDIUM or LOW) to values selected from different columns in ArcMap 10.3
I selected the two values from the two columns ("MAIN_ROCK" and "SUB_ROCKS") using SELECT BY ATTRIBUTES as follows:
"MAIN_ROCK"='gravel" AND "SUB_ROCKS" in ('mudstone tephra loess','sand mud','sand mud peat','sandstone mudstone tephra silt lignite','sandstone siltstone mudstone limestone silt lignite')
I want these highlighted main and sub rocks to be called "HIGH" in new column. So, I created another text field and named it CATEGORY.
I used field calculator while these main and sub-rocks are highlighted and wrote 'HIGH' in the field calculator of CATEGORY column but I got the message below
Any idea how can I do this?