Alteryx Designer

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

Formula help... easy solution I am sure!

Highlighted
5 - Atom

Hey,

 

I need the following excel formula to work in Alteryx... =IF(ISNUMBER(SEARCH("dinner", A1)),"Yes","No")

 

Any help appreciated! I am sure this is simple but I am very new to the Alteryx world!

 

Cheers,

 

Harry

Highlighted
12 - Quasar
12 - Quasar

Hello @HarryRoles 

 

Not sure if this is what you are looking for?

 

IF IsNumber([Field1]) AND Contains([Field1], "dinner") THEN "Yes" ELSE 'No' ENDIF

 

If not, could you please attach an excel with the example and formula.

 

Thanks,

Yug

Highlighted
8 - Asteroid

Hey Harry,

 

I believe that this would work for you

 

if Contains([Field1], "dinner") then "yes" else "no" endif

 

Where Field1 is the name of a column with the text you are looking for.

 

Cheers,

Igor

Labels