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,
Solved! Go to Solution.
Hi @AmritJ replace "BLANK" with Null()
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?
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
Or simply replace "blank" with " "
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!
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!