Description Field

[jerryc1]

I have a field in one of my data source tables, "Project Status" that uses a single character as the field values. I want to create a new field that has the corresponding description for each single character value that can be pulled in with the output data values. Example: Single values; A,  I, X. The descriptions for these single values are A = Approved, I = Inactive and X = Inspection Requested. I want to include the  corresponding description for each single character value in my output data analysis.

[AngelosPachis · Accepted solution]

Hi @jerryc1 ,

If I understand your question correctly, you can achieve this with a formula tool and the following expression

IF [Project Status]="A" THEN "Approved"
ELSEIF [Project Status]="I" THEN "Inactive"
ELSEIF [Project Status]="X" THEN "Inspection Requested"
ELSE "No Status"
ENDIF

Output :

Hope that helps,

Angelos

[jerryc1 · Accepted solution]

Thanks Angelos!