An old one but still saves me tonnes of time - drag Excel spreadsheets and other file-based inputs straight onto the canvas for the quickest way to get your inputs running!
Another is when you do a select - and use the option to "Deselect duplicates". Quickest way to clean up joins on a key.
@SeanAdams I also do this with Alteryx workflows to open them in the same window but on a new tab. This saves lots of time because you don't have to wait for a new instance of Alteryx to open each time.
When writing to a database, use a select tool before the output tool to make sure all field types and lengths match to avoid errors as you are writing out the data.
You can use the multi field formula to change multiple field types at a time.
Every system has an internal representation of dates, which allows for shortcuts. So in Excel or SQL - if you want to add 1 day, you just take <date cell> +1 since the whole numbers are days. To figure out the difference in days between 2 dates in excel, you could use formulas or you could just take Date2-date1 and you have difference in days.
In Alteryx the rules are different, but they still lend themselves to some useful shortcuts.
Dates & datetimes appear to be stored internally as strings (please correct me if I'm wrong) - so you can work with dates with text manipulation:
Knowing that dates and date-times are stored under the covers as text makes manipulation a little easier and opens up some cute shortcuts!
A different kind of trick. If Alteryx is not activating with an "Invalid JSON primitive" warning message, and if you use a web proxy servers, try this trick: simply load Internet Explorer and target an external website. Your proxy may not be active, and this will ensure that it is. Then re-try activating Alteryx. It may just work!
(We recently deployed new machines for several users... they had this activation issue and it appeared intermittent.... the last user to reactivate it, just-so-happens to almost never go cruising the web. This surprisingly simply trick got her up and running after weeks of trying even some fairly irrational things. Needless to say it is now burned into my memory forever. LOL.)
Not sure if anyone else has workflow OCD, but I do.
Anyone else not able to bear their connections not lining up?
Not to worry, you can use the arrow keys to align the tools.
Ctrl + Up will make smaller movements
Ctrl + Shift and + will align tools vertically
Ctrl + Shift and - will align tools horizontally
I also use the Right-click -> Make Connection Wireless a lot too
Another simple one that saves time-wasting: select specific fields in the browse tool.
Often you are not interested in all the fields in your data set, and are simply verifying changes you have made to the data in a couple of fields.
Using the check boxes you can limit the browse tool to show only the relevant fields. This configuration doesn't change so you can have browse tools that help you check specific parts of the workflow, without having to scroll left and right to look for those fields each time.
If you are manipulating a date or string field with lots of repeated values, use a multi-row formula to avoid Alteryx doing the same formula on the same value thousands of times. To take advantage of this, group the data by the field(s) you are parsing then use an if statement in the following format:
IF [Field2Parse] = [Row-1:Field2Parse] THEN [Row-1:OutputField] ELSE MyStringFunction([Field2Parse]) ENDIF