Setting a certain letter as a word

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

Alteryx_1.JPG

Alteryx_2.JPG

Datasets

Accepted answers

IraWatt

Hey @Sjkitts,

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

IraWatt

@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?

All comments

binu_acs

@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'

Alteryx3.JPG

IraWatt

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

Alteryx_4.JPG

IraWatt

@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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703