I am trying to clear entries in columns using the field calculator but with my current script, it removes all the data from all the rows. Basically, if the Historical column is equal to 'Historical Survey', I want it to replace the field text with
'<Null>' but if the historical column is equal to 'Most recent survey', I want it to keep the text in that cell.
The full script is:
Expression line: reclass(!Key_Biomec!,!Historical!) def reclass(Key_Biomec, Historical): if (Historical == 'Historical Survey'): return '<Null>'
Currently, this script removes all the data from the fields, no matter if they are labelled 'Historical Surveys' or 'Most recent surveys'. How to solve this issue?