Geoevent Field Calculator - If > elseif > then

[AllenScully]

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.

Thanks - 

Allen

[GarrettMelvin]

I know this is an older thread, but have you tried a Choice Element?  You could setup a choice with "field1 = 'AF' or field1 = 'AM' or field1 = 'AV'  or field1 = 'IH'", then follow with a field mapper that hard codes field2 as 'Y'.  In your choice element enable the "Otherwise" option, then follow with a field mapper that hard codes field2 as 'N'.  Finally merge the flows together for your output.