I am using Esri ArcMap 10.3:
I have a very large table so I do no want to do this manually it will take me months (50k+ rows of data)
My table looks something like below example.
Purpose new field
Of course my real table is way bigger and the 'purpose' field has many more unqiue values.
So what I would like to do is use the field calculator on my "new field" and have it add a value of 'xx' for each row that had a purpose value of 'apple' and jack'.
So basically if purpose was 'jack' or 'random' then new field will be 'xx'
This could be done with python im sure but I was just going to use the calculate field tool and write in an expression.