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.
Solved! Go to 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
Luck_C - Thank you for your help.
Happy to help @jjimenez! Don't forget to accept it as the solution so others can search for it easier.
Good to know. My first time posting a question.
Thanks again.