I am trying to get the ACTION_REASON_DESCRIPTION field to return Terminated, Retired, or Death, based off the conditional IF Statement Below. The Data Type is V_W String, yet the output is returned as either 0 or -1. I have tried every string data type possible and the output remains 0 or -1. I do not understand why I am getting this output rather than what I specified in my Formula Tool Expression.
Solved! Go to Solution.
IF [Employee_Status] = 'T' THEN 'Terminated' ELSEIF [Employee_Status] = 'R' THEN 'Retired' ELSEIF [Employee_Status] = 'D' THEN 'Death' ELSE Null() ENDIF
very close! You don't need to specify the new variable in the syntax.
Thanks,
Mark
This formula should be written to the specific field. In this particular example, the field name should be [ACTION_REASON_DESCRIPTION].
You can specify column name as in the attached image by selecting column drop down and selecting add column