Excel Formula to Alteryx Coding

TerryHoskins

Trying to remake the following Excel formula into Alteryx Workflow.

=IF(
OR(
IF(AND(S120642="",W120642="",Y120642="",Z120642="",AF120642="",AG120642=""),"Exclude","Include")="Exclude",
AND(
IF(AND(S120642="",W120642="",Y120642="",Z120642="",AF120642="",AG120642=""),"Exclude","Include")="Include",OR(AB120642<>"",AC120642<>"",AD120642<>"",AE120642<>""))
),
"Exclude","Include")

MoramHari

Add a Formula tool to your workflow, create a new column (or update an existing one), and paste this expression:

IF IsNull([S]) AND IsNull([W]) AND IsNull([Y]) AND IsNull([Z]) AND IsNull([AF]) AND IsNull([AG]) THEN
"Exclude"
ELSEIF !IsNull([AB]) OR !IsNull([AC]) OR !IsNull([AD]) OR !IsNull([AE]) THEN
"Exclude"
ELSE
"Include"
JSON

Note: Replace [S], [W], etc., with your actual Alteryx column names.