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 Knowledge Base

Definitive answers from Designer Desktop experts.
The difference between a heat map and a thematic map, explained.
View full article
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!
View full article
When writing expressions that evaluate NULL conditions, it is a common mistake to write the syntax as: IF [FieldX] = NULL() THEN ...   After all, this is how you would write the expression in SQL.  However, the actual syntax needs to be: IF ISNULL([FieldX]) THEN ....   Keep writing those expressions!
View full article
Where can I find commonly used Alteryx Cheat Sheets?
View full article
make pulling information from MongoDB easier
View full article
Errors from the R tool, and macros using R, such as the Association Analysis tool, can be a challenge to troubleshoot.
View full article
how to combine multiple header rows into one
View full article
  With the release of 10.6 came awesome new features, and an upgrade in the underlying R version (from 3.1.3 code named "Smooth Sidewalk," to 3.2.3 code named "Wooden Christmas-Tree").  Using the incompatible R version will cause errors in your R macros.     Simply make sure that your Predictive Tools download is the version compatible with your Alteryx Designer version:     Users on 10.5 should continue to use the R3.1.3 version.   When using Alteryx and Microsoft Revolution R Enterprise, a separate predictive tools install is required (in green). For details, see the Alteryx and Revolution Analytics Integration Guide.   And remember to use the non-Admin Predictive version with non-Admin versions of Alteryx Designer.   To install Predictive Tools for Alteryx 10.0, go to Previous Releases. For Alteryx 9.5, within Designer, go to Help > Install Predictive Tools.    Happy Alteryx-ing!
View full article
how to dynamically rename headers on multiple files in a directory
View full article
Getting the error: "not enough fields in record" from the Input Data Tool
View full article
Can I? Should I? While the answer to this question is yes, Alteryx can do that, it should only be done with a few caveats.
View full article
A large component of data blending is applying mathematical or transformational processes to subsets of your data.  Often, this requires isolating the data that complies with a certain criteria that you’ve set. The Conditional functions build expressions that allow you to apply processes to data that satisfy conditions you set.   #
View full article
Alteryx’s spatial functions are not limited to the tools found in the Spatial Palette.  The Formula Tool, for example, has a variety of spatial functions that expand the Designer’s spatial capabilities beyond those in the Spatial Tool Palette.  This article highlights the Formula Tool’s ability to create spatial objects, particularly points and lines, and calculate distance using the built-in expression library.
View full article
In order to open Access databases with the .accdb extension, you will need to download the Microsoft 2010 Office System Driver: Data Connectivity Components.
View full article
getting an error that says "Type mismatch in operator +" in my formula
View full article
Occasionally you may see one of these errors from the Join Multiple tool. It is a result of Cartesian joins.
View full article
Why am I getting the error "InvalidArgument=Value of '0' is not valid for 'itemIndex'. Parameter name: itemIndex" when trying to load an Excel file in and Input tool?
View full article
How to create null values in a data set. 
View full article
Selecting and blending records from within a group or category
View full article