Hi there!
I'm very new to Alteryx but excited by what I've seen so far. Can someone please help me translate the following Excel IF-THEN statement into Alteryx? I just want to add a new column and display the correct wording.
=IF(N2="ACS AND WDTS","D2C",IF(N2="CUST SERVICE","D2C",IF(N2="DOTCOM","D2C",IF(N2="NACS","D2C",IF(N2="RETAIL STORE","D2C",IF(N2="TELESALES","D2C",N2))))))
Solved! Go to Solution.
IF [N2] = "ACS AND WDTS"
THEN "D2C"
ELSEIF [N2]="CUST SERVICE"
THEN "D2C"
ELSEIF [N2]="DOTCOM"
THEN "D2C"
ELSEIF [N2]="NACS"
THEN "D2C"
ELSEIF [N2]="RETAIL STORE"
THEN "D2C"
ELSEIF [N2]="TELESALES"
THEN "D2C"
ELSE [N2]
ENDIF
Alternatively:
IF [N2] = "ACS AND WDTS" OR [N2]="CUST SERVICE" OR [N2]="DOTCOM" OR [N2]="NACS" OR [N2]="RETAIL STORE" OR [N2]="TELESALES"
THEN "D2C"
ELSE [N2]
ENDIF
Thanks for the reply!