Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

If statement error on filter

maygross
8 - Asteroid

I'm not really sure why I keep getting this error, everything seems like it should work. I keep getting a Malformed if statement error with this filter. The data type going into this filter is int 32 size 4. Please let me know what I need to fix here for this to work.

2 REPLIES 2
ChrisTX
16 - Nebula
16 - Nebula

Change ELSE IF to ELSEIF

 

Guessing the output data type in the Formula tool should correctly convert your GL ACCOUNT text value to INT

geraldo
13 - Pulsar

@maygross 

 


the GL_ACCOUNT_NUMBER field is actually an int32 but you are assigning a string to it. hence the error.
If it needs to be a string, create a new field in the formula e.g.: trim('4898924')

Labels
Top Solution Authors