IF ELSE STATEMENTS

[AmritJ]

Hi Community,

I am a fairly new user of Alteryx and would greatly appreciate any input on the recent IF statement problem that I am having.

It's a fairly simple one-

What am I doing wrong?

Thanks,

[JosephSerpis]

Hi @AmritJ replace "BLANK" with Null() 

[alex · Accepted solution]

No need for Null() if you if you are trying to get the word BLANK in your results.  Check Div Code data prior to your formula tool.  I tested the formula and it worked fine with my dummy data.  Can you be more specific on the exact problem?

[hroderick-thr]

Your expected results isn't clear. 

I suggest for debugging change it to ELSE [DivCd] so you can see what is in there.

Is [DivCd] a string format coming in? If not you may need to wrap it in ToString([DivCd])

Happy solving

[RPS]

Or simply replace "blank" with " "

[AmritJ]

Hi All,

Thanks for your inputs.

Turns out I had to convert the data type of my DivCd was V_WString. So I had to change it to Int32 so that it latches onto the numbers 10,20 ,etc and not any extra blank spaces within the cell!

[AmritJ]

Thanks Alex,

The data type needed to be Int in my case and not a string as my input data may be having extra spaces within the cell that I am looking for!