IIF OR FORMULA WITH CONTAINS

Question

Based on a certain criteria, I need to create another column, which would output "YES" or "NO".

I want "YES" as an output for the column, which contains a specific word (let's say "HELLO") and (OR in the Alteryx terms) I want "YES" for the column where the names equal to "Adam", "Steve", etc (that's a different column from where I have "HELLO").

So that would be an if formula with both contains and equals, I believe!

Any help would be much appreciated, thank you!

Qiu · Answer

@insomned 
I think we should make it more flexible.

Your second creteria seems not to be fixed therefore we should have a text input for easy maitenance.

0915-insomned.yxmd

Maskell_Rascal · Answer

Hi @insomned

Here is how you can do it.

IIF(Contains([Field1], 'HELLO') AND [Field2] IN ('Steve','Adam'),'YES','NO')

I'm using a contains to find "HELLO" in one field and an IN function to match a field to a small list of names.

Hope this helps.

Cheers!

Phil

Luke_C · Answer

Hi @insomned

Substitute your column names, but here's an example:

IF Contains([Field 1],'HELLO') OR [Field 2] in ('Adam','Steve')

Then 'YES'

Else 'NO'

Endif

New Workflow8.yxmd