Translate/Convert/Change numeric fields to string values

Question

Hi All,

I have a file with several fields where I have the numeric code 0 = No and 1 = Yes. I have other field that use 0, 1, and additional numbers where 0, and 1 don't equal yes no. Examples:

Field              Code with Meaning

Tax Bracket: 1 = 15% or less, 2 = 16-28%, 3+ over 28%

Investment Exp: 1 = None, 2 = Limited, 3 = Good, 4 = Extensive

Risk Tolerance: 1 = Conservative, 2=Conservative Moderate, 3=Moderate, 4=Moderate/Aggressive, 5=Aggressive

Trying to think of the best tool(s) or method to go about translating the number codes into string values.

Thanks!

CharlieS · Accepted Answer

There are a couple ways to achieve this, so I'll give a couple examples. The formula tool is probably the most direct. You'll use an IF statement that looks like this:

For the [Tax Bracket] field:

IF [Tax Bracket]==1 THEN "15% or Less"

ELSEIF [Tax Bracket]==2 THEN "16-28%"

ELSE "Over 28%" ENDIF

You'll need to either change the field type on this field to a string before you apply these values, or create a new field that's a string. The Find Replace tool will be another common option. I've attached an example workflow below.