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