Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Good to Know's (aka Gotcha's)

Kmaclean
8 - Asteroid

Hey Y'all,

 

Often I build workflows and have them scale to 100's of datasets which is easily done thanks to Alteryx,

 

However, down the line someone will report back to me with some fallout, and I begin the investigation and find that my unique tool happens to be case sensitive, which would have been good to know.

 

With that punchline being said, I was wondering if any other "Good to Know's" exist, so I put together a workflow showcasing some that I consider based upon the following;

  • The clarification does not exist in the Tool/Documentation (https://help.alteryx.com/)
  • 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;

Kmaclean_0-1603481737933.png

 

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;

Kmaclean_1-1603482206056.png

 

 

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)

 

 

  

1 REPLY 1
BrandonB
Alteryx
Alteryx

Definitely take a look at the Inspire 2019 Tips and Tricks PDF that was put together here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Inspire-2019-Tips-Tricks/ta-p/42567...

 

"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."

Labels