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.
The data formatted differently can yield different results
So if you ever need to Union together datasets with columns/data that may have different case formats, take the Unique of that data, transpose that data to Join on [ID] & [Column Name] & [Value], hopefully this helps;
The Min/Max/Sort Order while I do consider them still to be good to know, I will assume that industry standard for coding/regex is [a-zA-Z] and hopefully that holds true
As a counterpart and the standard I believe should be held to, these tools/formulas have the documentation/ability and have caused me zero headaches;
If there are any other "Good to Know's" out I would love to know about them (I am sure there are posts spread across here, and even ideas like the case-insensitive join: Case-Insensitive Join)
"Enclosed you will find 91 pages full of Tips + Tricks that will help you save clicks in Alteryx. The Tips and Tricks book covers our fan favorite tips for saving time when developing workflows and our best tips for organization. Utilize the book to learn everything from workflow design to organization, optimization, to our best time savers."