If-Then formula

skeen503979

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))))))

BrandonB

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