Does dictionary sort order always place capitals before lower case letters? For instance, in my sorting BMW-740Li precedes BMW-740i, which isn't logical to me...
Actually if you have "Use Dictionary Order" checked (which is down at the bottom of the Sort tool configuration...took me a few months of Alteryx use before I noticed that option was even there ), it will sort in alphabetical order with lower case first (e.g., a, A, b, B, c, C, etc.)
If you don't have that option checked, it will sort all Upper case first and then all lower case (e.g., A, B, C, a, b, c, etc.)
Check out the Sort Help Article for more details.
Ah, OK maybe I have that sort field backward then, and it's sorting "correctly" - at least in Alteryx's brain! Thanks!
