Formula tool

rshack2005

Hello - I am just getting into Alteryx and learning my way around w/o a SQL background. I am trying one of the weekly challenges and trying to create/ populate a new column based on the logic below (see image). Can anyone give me a steer what the formula would look like?

Help

Accepted answers

atcodedog05

Hi @rshack2005

The formula would be something like this

IF (!IsEmpty([B]) or !IsEmpty([P])) 
and !IsEmpty([D]) and !IsEmpty([S]) THEN "Include" 
ELSE "New" ENDIF

Hope this helps : )

All comments

atcodedog05

Hi @rshack2005

The formula would be something like this

IF (!IsEmpty([B]) or !IsEmpty([P])) 
and !IsEmpty([D]) and !IsEmpty([S]) THEN "Include" 
ELSE "New" ENDIF

Hope this helps : )

rshack2005

Thanks very much mate!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703