Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

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

Formula tool

rshack2005
6 - Meteoroid

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?

rshack2005_0-1633094640227.png

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

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
6 - Meteoroid
Thanks very much mate!
atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @rshack2005 

Cheers and have a nice day!

Labels