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.
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
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"