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.
Note: This article is out of date. CLICK HERE for up-to-date, single source help on magnification, mouse keys, mouse, and keyboard shortcuts in the Alteryx Designer product.
There are many different keyboard shortcuts to help you in your task of building modules in Alteryx. As in most software packages, the standard set of keyboard functions native to the Windows operating system also apply to Alteryx.
Handy shortcuts specific to Alteryx: Ctrl + Alt + B : Show/Hide Toolbar Ctrl + Alt + T : Show/Hide Toolbox Ctrl + Alt + V : Show/Hide Overview Ctrl + Alt + R : Show/Hide Results Window Ctrl + Alt + C : Show/Hide Configuration Window
Ctrl + Alt + D : Show/Hide Interface Designer Ctrl + Shift + B : Add all Browses after selected tools Ctrl + R : Run Workflow F5 : Refresh Configuration Ctrl + Shift + - : Align selected tools horizontally Ctrl + Shift + + : Align selected tools vertically Ctrl + Arrow Key : Nudge tool by one pixel
The full list of keyboard shortcuts can be found here.
Canvas Navigation was updated in Alteryx Version 10.1. Check out the blog posted here.
Standard Shortcuts Ctrl + N : Open a new workflow Ctrl + O : Open an existing workflow Ctrl + Z : Undo Ctrl + Y : Redo Ctrl + F : Find Tool (this allows you to find tools in your workflow by name or number) Ctrl + X : Cut selected (in the canvas this will cut the selected tools, text will be cut if the text is selected inside the tool's configuration window) Ctrl + C : Copy selected tools (in the canvas this will copy the selected tools, text will be copied if the text is selected inside the tool's configuration window. Also, you can select specific rows from a browse tool and copy those rows using this command) Ctrl + V : Paste tools (if rows have been copied from a Browse tool this command will create a Text Input on the canvas of copied rows from the clipboard) Ctrl + A : Selects all tools in the workflow Ctrl + S : Save your module (SaveAs if this is the first time the module is being saved) F1 :This single button will bring up the help file specific to the tool you have selected on the canvas, otherwise it pulls up the generic help window. Ctrl + Tab : Switch between open workflows (if you have more than one workflow open in a single session of Alteryx)
Other commands and Handy Shortcuts: Right Click and Drag : Inside a select tool, or any tool with "Select" functionality, you can select a field, or group of fields, and right click and drag those fields to a new destination in the field structure. This eliminates needing to click the Up/Down arrows to reorder fields. Hold down the mouse wheel : Pan the canvas Space Bar + Left mouse click : Pan the canvas Shift + mouse wheel : Scroll canvas horizontally Ctrl + roll mouse wheel : Zoom the Canvas Ctrl + Arrow Key : Nudge tool by one pixel Splash Screen : To remove the splash screen while the program loads simply click on the image Open one or more files : Drag files from Windows Explorer directly to the canvas. Workflow files (*.yxmd, *.yxwz, *.yxmc) will open directly in a new tab on the module canvas. Data files will be represented by a configured Input Tool for each data file on the active workflow.
If you are installing two different versions of Alteryx Designer and their respective predictive tools- there is an order of operation.
1. Download and Install the Administrative Version of Alteryx Designer.
2. Download and Install the Administrative Version of Alteryx R/Predictive tools.
3. Download and Install the Non-Administrative Version of Alteryx Designer.
4. Download and Install the Non-Administrative Version of Alteryx R/Predictive tools.
Tips + Tricks is at Inspire Europe ! We added some exciting 2019.3 tips & tricks to our book for this occasion. New version is attached.
Thanks to everyone that joined us in Nashville for our 2019 Tips and Tricks tour and special thanks to everyone who submitted tips for our Tips + Tricks Book.
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.
We hope to see you all at our next Tips and Tricks session.
@MargaritaW , @JessicaS & @HenrietteH
Your Customer Support Engineering Team
Sometimes, especially when interacting with tools/files outside Alteryx, you need to explicitly control the order of tool execution. The classic example is a process whereby you 1) INSERT to a SQL table where an auto-incrementing ID is applied 2) read the records back in order to get the auto-incremented id 3) insert the auto-incremented ID into a different table.
In Alteryx worflow streams that terminate (as in an Output or Render), you can't reliably use Block Until Done to control the stream. One way to reliably control the order of events is with batch macros.
Batch macros guarantee that 1) every iteration is complete before the next iteration begins, and 2) that all iterations are complete before the macro reports itself complete. So if you place a process inside a batch macro and create an output stream from that macro, all processing will be done and the macro still can exist in the middle a workflow stream. You don't even need a Block Until Done as part of the process.
Please see the attached examples
Sometimes large amounts of data can 'overwhelm' a tool or process in your workflow and make it appear like it is stuck or frozen. This was the case recently when a user attempted to pass 7 million rows of data to a CASS tool . Splitting these records into smaller chunks makes the process run much quicker.
Welcome to Alteryx 11.0 new feature Data Profiling in the Browse Tool. We are excited about this and we hope you will be too! The Data Profiling in the Browse tool was created to assist the user in better understanding the quality of their data at any point within the workflow. This option will assist users in understanding the quality of their data, assist in troubleshooting and help fix issues that may arise when attempting to parse, join, or output their data.
Analytic Starter Kits teach you how to prep, blend, and analyze your data faster than using tools like Excel or SQL coding; guide you through how to build sophisticated insights such as market basket analysis or predictive A/B testing; and show you how to output beautiful Tableau , Microsoft Power BI , Qlik or Salesforce Wave visualizations to explore and understand your data and insights.
To get a better understanding of how to properly leverage a machine’s resources to use Alteryx, it can be very helpful to understand how the Alteryx Engine functions. To clear up any haziness surrounding the term “Alteryx Engine”, this article covers what happens when you click the Run Button
Unbeknown to many, by default Alteryx saves your open workflows every 10 minutes, keeps the last three iterations of them, and keeps them around for 30 days since the last save. As you can imagine, many people are very happy to find this out when they frantically come to Support hoping for some way to resurrect a deleted or corrupted workflow. I have always found Alteryx to be an incredibly stable program, but it is nice knowing that my workflows will still be there in an unfortunate emergency, self-inflicted or otherwise.
From my experience, this is something that a lot of people either ignore or don't realize is there. What most people do realize is that for some reason, every one of their workflows has a similarly named copy, but with a .bak extension. The important thing to know is that when you least expect it, this file can become a lifesaver if something happens to your original workflow, so please don't delete them!
To recover autosaved files: Go to File > Open Autosaved Files
To change the settings: Go to the 'Advanced' tab under Options > User Settings > Edit User Settings
Open an Autosaved Workflow
To open an autosaved file, simply go to the menu File > Open Workflow > Open Autosaved Files:
The following screen will open:
You simply click on the iteration of the workflow that you want to restore and then you have the choice of either opening that workflow or saving it to a directory. If you open the workflow directly from this screen, Alteryx will open up a temporary version of that workflow that you will need to save to an appropriate directory of your choosing.
Edit the Autosave Defaults
To edit the Autosave settings, go to 'Advanced' tab under Options > User Settings > Edit User Settings.
The Autosave options are highlighted in yellow below. As you can see below, you can adjust the interval in minutes that the workflow is saved, how many iterations of the workflow to save and how many days to keep the file.
As you can see, the Autosave feature is very straightforward, while at the same time it can be the most important feature you ever used!
Check it out in our Help too!
Alteryx includes a printing feature which allows you to print out a workflow you've developed.
To Print, navigate to File > Print
To change the Print Settings: File > Print Settings
This is a simple feature that does not require much explanation, so I will make this quick.
The Print Screen
Print the workflow or select a printer with the drop-down arrow.
Set the zoom level of the preview window with the down arrow or fit to the page by clicking on the magnifying glass.
Choose how many tiles to print to; larger workflows may require multiple tiles.
Scroll through the workflow pages.
Change the scale so that the entire workflow fits on a single page or the original or custom scale.
Change the format to Landscape or Portrait.
The preview of your workflow.
This feature is very useful when reviewing the overall workflow parts with colleagues. Enjoy!
Everyone has their own way of organizing their window setup in Alteryx and there are a few tricks to make your canvas as user-friendly as possible.
My new favorite is the Ctrl+Tab and holding down Ctrl. Similar to toggling internet browser windows, this allows the user to toggle between workflows, but also tool windows. You can then place tool windows in the same position and then toggle between them. This will allow more room on the user's canvas since all of the tool windows will be in one spot!
Another great feature to open up canvas space is the Auto Hide. This will create tabs for you with each of the tool windows and hide them until you select the tab or use the feature above. When your window is docked you can hover over the pin (see below), click the pin, and your window will change to Undockable and Auto Hide. You should then see a tab on the screen with the window's name.
We have many ways to configure your tool windows in Alteryx, so don't forget about the other options you have when you select the down arrow on the tool window (see below). These options can be beneficial when optimizing your view.
Floating: Allows users to move the window around the canvas as you please. This also allows you to move the window to another monitor.
Dockable: Allows users to place their window in a certain position on the canvas and will not move when selected or viewed.
Tabbed Document: This configuration will place your tool window in the same position as if it was another workflow.
Auto Hide: Hides the tool window until the tab is selected.
Hide: Hides the tool window.
Hope these tips help keep your canvas view!
Alteryx is designed to use all of the resources it possibly can. In order to make Alteryx run as fast as possible, it tries to balance the use of as much CPU, memory, and disk I/O as possible. The good news is that most of the resource utilization can be controlled. You can limit the amount of memory that is used on a system, user, or module level. The Sort/Join memory setting is not a maximum memory usage setting; it’s more like a minimum. One part of Alteryx (sorts) that benefits from having a big chunk of memory will take that entire amount right from the start. It will be split between all the sorts in your module, but other tools will still use memory outside that sort/join block. Some of them (e.g. drive times with a long maximum time) can use a lot. If a sorting can be done entirely in memory, it will go faster than if we have to fall back to temp files, so that’s why it’s good to set this higher. But if the total memory usage on the system pushes it into virtual memory, you’ll be swapping data to disk in a much less optimal way, and performance will be much worse and that’s why setting it too high is a bigger concern. The Default Dedicated Sort/Join Memory Usage can be found in the Designer at Options > User Settings > Edit User Settings Best Practices on Memory Settings 32-bit machines*: Setting should be on the lower, conservative side. No matter how much actual RAM is there, only has at maximum 1 GB available, as soon as it is set higher, the machine will cross over into virtual memory and be unable to recover. A 32-bit machine should never have a setting over 1000MB, and 512 is a good setting. Set it low (128 MB), especially when using Adobe products simultaneously with Alteryx. 64-bit machines: Set this in the system settings to half your physical memory divided by the number of simultaneous processes you expect to run. If you have 8 GB of RAM and run 2 processes at a time, your Sort/Join memory should be set to 2GB. You might set it lower if you expect to be doing a lot of memory intensive stuff on the machine besides Alteryx Set your Dedicated Sort/Join Memory Usage lower or higher on a per-module basis depending on the use of your computer, doing memory intensive non-sort work (i.e. large drive-times) then lower it, doing memory intensive sort-work then higher.
*Please refer to this link for additional details on 32-bit support for Designer
This question is one of the most commonly asked questions from clients I interact with and some treat it as a personal challenge to see how fast they can get their module to run. However, in the famous words of our CTO Ned Harding "Although Alteryx can be very fast, since it is such a general tool, it is only as good as the module that you have authored".
There are multiple strategies to improving the speed of a workflow from using a select tool to reduce field sizes or looking at the default sort join memory, however the first fundamental process is benchmarking.
The recommended process is to run the workflow three times to ensure the data has cached.
If the workflow has not cached the data then this can cause slower run times, so to ensure this is a fair test running the workflow three times should ensure all the data is cached.
If you want to run without cached data you will have to reboot your machine between runs.
Once you have the total time the workflow takes to complete/run you can now look at optimizing.
Optimizing your workflow!
Alteryx is designed to use all of the resources it possibly can. In order to make Alteryx run as fast as possible, it tries to balance the use of as much CPU, memory, and disk I/O as possible.
Set your Dedicated Sort/Join Memory Usage lower or higher on a per-Workflow basis depending on the use of your computer.
Sort work refers to the sort tool and other similar tools in re-ordering your data. Join work refers to any of the join processes.
If you are doing memory intensive non-sort work (i .e . large drive-times) then lower it!
If you are doing memory intensive sort-work then higher it.
Go to the Workflow Configuration > Runtime tab > Dedicated Sort/Join Memory Usage > Use Specific Amount
The Sort/Join memory setting is not a maximum memory usage setting; its more like a minimum, this allocated memory will be split between all the tools that sort in your workflow, but other tools will still use memory outside that sort/join block. Some of them (e .g . drive times with a long maximum time) can use a lot.
Where do I find the Sort/Join memory options?
To set a user level default dedicated Sort/Join Memory Usage, go to Options > User Settings > Edit User Settings > Defaults tab.
The global Default Dedicated Sort/Join Memory Usage at System level can be found at Alteryx > Options > Advanced Options > System Settings > Engine > Default sort/join memory usage (MB).
*******For machine bit version memory considerations please see here.
Lean for more speed!
A best practice to optimize the performance of your workflows is to remove data that won’t be needed for downstream processing as quickly as possible. You can always bring that data back into the workflow later if necessary.
The select tool removes fields or columns from your data. Other tools such as join, join multiple, spatial match, find nearest, and to a certain degree Transform tools and Reporting tools have some select functionality that you can utilize within the tool to reduce the need to add additional select tools.
Another good way to optimize workflow performance is using the filter tool to remove unnecessary data.
The filter tool queries records in your file that meet specified criteria and identifies these records in your data, such as ZIP = 01001 . You may choose to handle records that come from the True output differently than the false output by connecting additional tools to the workflow on either side. This will allow smaller amounts of data to be passed downstream.
Auto Field Tool
Optimize your workflow for speed by setting the field type to the most efficient type and smallest possible size.
Use the auto field tool right after your Input Data tool to assign the most efficient type and size to your fields.
Another benefit of using the auto field tool is that it will reduce the size of your output file.
Enable Performance Profiling
This option will allow you to see a milliseconds and percentage breakdown per tool in your workflow.
Having this breakdown will allow you to pinpoint the slower tools/processes in your workflow and use the methods suggested in this article to improve that tool/process.
Performance profiling can be found Workflow > Runtime > Enable Performance Profiling.
Disable All Browse tools
The Browse tool quickly becomes a data artisans best friend, it allows to see/review the entire data at any given step in the workflow building process, however, each of these browse tools creates a temporary yxdb and writing these files do take some time and slow down the processing.
There is an option to simply disable them so they can be easily enabled if need it. This setting can be found at Workflow > Runtime > Disable All Browse Tools.
Set your limits: Record Limit for the Inputs
When developing your Workflow, there is no need to bring in all your data during testing.
Use the Record Limit option in the Properties for the Input to bring enough records for testing.
If you want to set limits for all input tools in your workflow, you can also do this under the Runtime tab under Workflow – Configuration.
The tool container allows the user to organize a workflow better by combining tools in logical groups.
Tool Containers can be disabled to run only certain portions of the workflow, effectively bypassing tools for a quicker run.
Designer now has the ability to cache data from relational databases through the input tool.
When checked, data is stored in an yxdb file on disk so that data sources are not hit repeatedly during workflow development.
Data can only be cached when running a workflow in an Alteryx Designer session. The setting is ignored when the workflow is run in the scheduler, in the gallery, or from the command line.
The Connection progress is a great way to keep track of the number of records and the size of the data going from one tool to another. In addition to that, the thickness of he connection itself varies depending on the size of data passing through (great for troubleshooting).
The default setting for the Connection Progress is “Show Only When Running” however leaving this set as ‘Show” will allow you to investigate the size of the data at certain points permanently (Properties for the Canvas > Connection progress).
If you want more detail on any of the points mentioned above make sure to check out the great Tips and Tricks articles from Margarita Wilshire et al!
Tips & Tricks 2016
Tips & Tricks 2015
Tips & Tricks 2014