Need to create new column based on text from another column

[jjimenez]

I need help using the Formula tool OR another tool to create a new column based on text in a specified column coming out of a Join tool. 

In column KVI_NAME if text is "foreground" need to populate in new column "30%"

or

In column KVI_NAME if text is "background" need to populate in new column "40% - 50%"

**The new column that will need to be created will have subject "Index". 

  

This is the error I keep receiving:

Any help will be greatly appreciated. 

[Luke_C · Accepted solution]

Hi @jjimenez 

Here is a formula you can use. You're on the right track but you'll want to use an if statement with a contains function to check for the keywords. You'll also want to make a new field instead of updating the existing KVI field.

if contains([KVI_NAME],'foreground')
then '30%'
elseif contains([KVI_NAME],'background')
then '40%'
else null()
endif

[jjimenez]

Luck_C - Thank you for your help. 

[Luke_C]

Happy to help @jjimenez! Don't forget to accept it as the solution so others can search for it easier. 

[jjimenez]

Good to know. My first time posting a question. 

Thanks again.