Using the IF formula in Alteryx

Hi all,

I am relatively new to using Alteryx and I am attempting to write a formula where if either/both column A and B contains 'Exceeds' then I require a 'Yes' otherwise I need the formula to show as 'No'.

Any assistance is greatly appreciate!

Many thanks,

Hannah

Workflow

Input

Reporting

Accepted answers

afv2688

Hello @HannahSwain ,

The formula would be like this

IF [A] = "Exceeds" OR [B] = "Exceeds" THEN "YES" ELSE "NO" ENDIF

P.d: Welcome to the community

Cheers!

All comments

afv2688

Hello @HannahSwain ,

The formula would be like this

IF [A] = "Exceeds" OR [B] = "Exceeds" THEN "YES" ELSE "NO" ENDIF

P.d: Welcome to the community

Cheers!

Loic

Look at the attached workflow.

I created 2 formulas. One is a Boolean (True/False) the other is a string that returns Yes/No. It uses contains (vs. perfect equal sign) and it takes into account that the case could be different.

Match Boolean:

Contains(LowerCase([A]),"exceeds") OR Contains(LowerCase([B]),"exceeds")

Match Yes/No:

IF Contains(LowerCase([A]),"exceeds") OR Contains(LowerCase([B]),"exceeds") then "Yes"
ELSE "No"
ENDIF

Match.yxmd

vplante

Works fine, thanks !

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703