This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
For all the time I've used Alteryx, I thought that IF "test" = "TEST" would evaluate to false. Today I realised that isn't the case and I was surprised !!! I contacted @MarqueeCrew and he almost fell over saying "that isn't right".
So ... I'm very surprised that "equals" performs like it does, I've supplied some workarounds but when did this functionality change ?
I think the easiest way provided changing casing upstream of the formula so you don't have to jump through formulaic hoops. However, if case is critical to your analysis, with a little more work you can use the regexmatch function which has a case sensitivity parameter:
then "[a] is upper case"
else "[a] is NOT upper case"