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 · Accepted 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

[BrandonB]

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

[skeen503979]

Thanks for the reply!