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
Solved! Go to Solution.
@Sjkitts can you check the field size in your desired output column? If it is 1 then it will only show one character
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
Hey @Sjkitts,
That is after the formula tool, you'll need to update it before the formula tool
Hell Yes! Thank you so much!
No worries @Sjkitts 😄 has happened to me a few times before
@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?
Awesome, thanks that makes sense!