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