Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

If/Then statement - help!

kiwipops
6 - Meteoroid

First time poster here, so pardon if I've missed any posting guidance. 🙂

I am trying to get all instances of "word" from one column to output "YES" into another column (I've looked around for alternatives, but having a hard time find a solution that fits my format!).

If column [A] contains "word", then I need the word "yes" to output into column [B]. I've tried a few variations of if/then statements, but I'm just getting null results.

Thanks in advance!

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @kiwipops ,

 

Take a look at my example and see if that works for you.

 

Best,

Fernando Vizcaino

kiwipops
6 - Meteoroid

This is close--I realized I worded my ask wrong (sorry!). It should be if in Column A contains "x/word" (so pulling out keywords from the field vs. a direct match). Could I tailor your formula that way?

Thanks again!

fmvizcaino
17 - Castor
17 - Castor

Hi @kiwipops ,

 

You can use the following formula.

if contains([Field1],'word') then 'yes'
else null()
endif

 

Best,

Fernando Vizcaino

kiwipops
6 - Meteoroid

Thank you--that did the trick! I knew it would be more simple than what I was attempting to use, ha! 🙂

Labels