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?

[atcodedog05 · Accepted solution]

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!

[atcodedog05]

Happy to help : ) @rshack2005 

Cheers and have a nice day!