Alteryx Designer Desktop Discussions

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

IF statement not working

ppatane
8 - Asteroid

Hi all,
The following statement errors out at the equal sign

 

if Left([project_code],1) = 4 then
"Firm Administration"
else
"Client Charge"
endif

 

both the projct_code field and the field I am saving to are V_String

2 REPLIES 2
binuacs
20 - Arcturus

@ppatane the 4 should be put in quotes 

 

if Left([project_code],1) = ‘4’ then
"Firm Administration"
else
"Client Charge"
endif

ppatane
8 - Asteroid

D'oh! Rookie mistake on my part.  Thanks!

Labels