Trying to use the field calculator processor in a Geoevent service to look at an existing field and generate a Y/N value that gets written into a different column based on the values of the other field -
I know VB doesn't work in the field calculator, so I'm wondering how to code the expression -
basically it's this:
IF field1 in ('AF','AM','AV','IH') then field2 = 'Y'
else field2 = 'N'
Can this be done in the simple field calculator processor? Hard to find documentation on coding these expressions.