Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multi-conditional IF THEN ELSEIF ELSE ENDIF erroring out while typing.

ppatane
8 - Asteroid

When I am typing in a formula, it all goes in fine until I type the endif, then I get the red squiggly error symbol under the =.  It goes bad as I type the last letter f.  Everything is meant to be V_String.  See screenshots below:

 

comm 1.jpgcomm 2.jpg

4 REPLIES 4
ppatane
8 - Asteroid

Please ignore, user error.  The Region field was Boolean, should've been V String.  Apologies.

caltang
17 - Castor
17 - Castor

One way to avoid this in the future is to use either the Field Info tool, Select tool, or even the Auto-Field tool to see your data types - then you won't run into this again @ppatane 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
ppatane
8 - Asteroid

@caltang Grazie!  Will do.

snadeau456
8 - Asteroid

Any suggestions as to why this formula is not working - tried several different ways.  Thank you

 

If ([Role] = "PCP" or [Role] = "BOTH") and
([Specialty] ="General Practice” Then "Role match"
ElseIF
[Specialty] = “Family Practice” Then "Role match"
ElseIF
[Specialty] = “Geriatric Medicine/Family Prac” Then "Role match"
ElseIF
[Specialty] = “Internal Medicine” Then "Role match"
ElseIF
[Specialty] = “Geriatric Medicine/Internal Me” Then "Role match"
ElseIF
[Specialty] = “Adolescent Medicine” Then "Role match"
ElseIF
[Specialty] = "Pediatrics” Then "Role match"
ElseIF
[Specialty] = “Pediatric Internal Medicine” Then "Role match"
ElseIF
[Specialty] = “Obstetrics & Gynecology – CA P” Then "Role match"
ElseIF
[Specialty] = “General Practice - Dental”)
Else "Role MisMatch"
ENDIF

Labels
Top Solution Authors