Setting a certain letter as a word

[Sjkitts]

In a certain column in my output I want this column to say employee if the input file read F so I put in this code but it is just shows as "E"

anything that I'm doing wrong? See screenshots for more information 

IF [EMPTYPE]= "f" THEN "Employee" ELSE 'False' ENDIF

[binuacs]

@Sjkitts can you check the  field size  in your desired output column? If it is 1 then it will only show one character 

[IraWatt]

Hey @Sjkitts,

Your column has a size of 1 use a select tool before the formula tool to increase the size of the EMPTYPE column to 200.

Any questions or issues please ask :)
HTH!
Ira

[Sjkitts]

It was at 1 before and I just set it as 200 but I'm still seeing 'e'

[IraWatt · Accepted solution]

Hey @Sjkitts,

That is after the formula tool, you'll need to update it before the formula tool

[Sjkitts]

Hell Yes! Thank you so much!

[IraWatt]

No worries @Sjkitts 😄 has happened to me a few times before

[Sjkitts]

wait one last question.......now I need to set a different letter to another word but I'm getting an error.

IF [EMPTYPE]= "f" THEN "Employee" ELSE 'False' and
IF [EMPTYPE]= "A" THEN "Supplier/Contractor" ELSE 'False' ENDIF

[IraWatt · Accepted solution]

@Sjkitts Try:

IF [EMPTYPE]= "f" THEN "Employee" ELSEIF

[EMPTYPE]= "A" THEN "Supplier/Contractor" ELSE 'False' ENDIF

It should be ELSEIF in your second ELSE, not sure what the "'False' and" is supposed to check?

[Sjkitts]

Awesome, thanks that makes sense!