Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

If-Then formula

Highlighted
7 - Meteor

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

 

skeen503979_0-1580495737200.png

Highlighted
Alteryx
Alteryx

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

 

Highlighted
Alteryx
Alteryx

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

7 - Meteor

Thanks for the reply!

Labels