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

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