Formula help... easy solution I am sure!

[HarryRoles]

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

[ydmuley]

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

[igorp · Accepted solution]

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