ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
 Alteryx has a full set of integrated predictive tools but even with developers working at full speed, it is hard to keep up with the R community. Sometimes users want to install and utilize their favorite R packages. This post demonstrates how to use and install additional R packages.
View full article
Troubleshooting the Error: The R.exe exit code (n) indicated an error
View full article
This article details on the steps to read/extract password protected excel file in Alteryx Designer using the R code.
View full article
Error while installing additional R packages in Alteryx Designer - "GenericTool (1): Can't find plugin "AlteryxRPluginEngine.dll""
View full article
Data preparation and investigation are a must for successful Predictive Modeling.
View full article
This article describes and explains the outputs of the Decision Tree Tool.
View full article
This error occurs when the validation sample contains inconsistent data with the evaluation sample causing different data types for the same column.
View full article
An ETS model, otherwise known as exponential smoothing, estimates single variable forecasts using weighted averages of past observations. There is more weight given to recent observations with a gradual and constant rate of decrease for the observation weight over time. Depending on the method used, there is a smoothing equation for one or more of the following: level, trend, and seasonality.
View full article
ARIMA stands for Autoregressive Integrated Moving Average. An ARIMA model produces time series forecasts using autoregressive integrated moving averages based on a single variable model or covariate model. Generally, either the AR or MA terms are used, models with both terms are less common.
View full article
Fix "Error: package or namespace load failed for 'AlteryxRDataX'" Following an new installation of the predictive tools, while trying to run a workflow involving R tool or any macros that use R tool (most of the predictive tools for example), you may face following error message: Error: R (1): Error: package or namespace load failed for 'AlteryxRDataX': Info: R (1): .onLoad failed in loadNamespace() for 'AlteryxRDataX', details: Info: R (1): call: NULL Info: R (1): error: package or namespace load failed for 'showtext': Info: R (1): .onLoad failed in loadNamespace() for 'showtext', details: Info: R (1): call: utils::unzip(font_file, exdir = out_dir, overwrite = FALSE) Info: R (1): error: 'exdir' does not exist Error: R (1): Error: Unable to load the AlteryxRDataX package - Use the R installer provided by Alteryx Error: R (1): Execution halted Example: Environment Product - Alteryx Designer All versions Product - Predictive tools All versions Cause This error occurs if of the R packages used by Alteryx for the R tool (https://cran.r-project.org/web/packages/showtext/index.html), can't freely access the folder defined by environment variable TMPDIR, TMP or TEMP. Package will stop as soon as one of them could be find found. They will be checked in this particular order, with user variable taking precedence over system variables if the 2 are defined). Example: In the following, example, environment variables will be read in following order (first available folder will be used): system TMP user TEMP system TEMP As C:\Windows\Temp exists but it not accessible for current user (see below), error will occur: Solution Close Designer Open Control Panel Open System Open Advanced system settings Click on Environment Variables Create a user environment variable called TMPor (TMPDIRif TMPalready exists) with a value set to a fully available folder (example: %25LOCALAPPDATA%25\Temp). Click on OK to close the window. 7. Start Designer and run your workflow or test again
View full article
This article has an attached macro from Dr. Dan for grouping linear regressions by unique values in a column.
View full article
This article includes a macro for obtaining parsed statistics from the Linear Regression tool.
View full article
Errors and warnings occur when predictive model names contain spaces
View full article
If you are installing two different versions of Alteryx Designer and their respective predictive tools- there is an order of operation.    1.  Install the Administrative Version of Alteryx Designer. 2.  Install the Administrative Version of Alteryx R/Predictive tools. 3.  Install the Non-Administrative Version of Alteryx Designer. 4.  Install the Non-Administrative Version of Alteryx R/Predictive tools.
View full article
Predictive Tools or R-Tool missing in Designer   Cause 1   After the Designer installation, the separate Predictive Tools installation is not yet complete.   Solution   The toolbar with Predictive Tools and the R Tool in the Developer Toolbar are not part of the Designer installation. These tools require a separate installation matching the non-Admin or Admin version of Designer. To verify the version of Designer installed, first go to the Help, About menu. Then, go to downloads.alteryx.com and click on the Designer tab to find the matching version of the Predictive tools in the list.     Cause 2   Installation of the incorrect version of the Predictive Tools download occurred.   Solution   Be sure to install the version of the Predictive Tools that match Designer, either non-Admin or Admin.   Cause 3   There are additional initialization files beyond those generated by the Predictive Tools installation.   Solution   Designer will check three locations for the initialization (.ini) files that contain settings by needed by R based tools that run in Alteryx. These .ini files include the folder location of plug-ins and tool macros. The correct version of the R libraries and modules is included in the .ini file settings as well. Note that all tools in the Predictive Tool Download need information from the R folders in the initialization settings to run.   When there are custom tools from the Alteryx Public Gallery, or other applications besides those from Alteryx referencing R libraries and modules, there can be initialization settings that misdirect Designer to the wrong folders. For example, an additional .ini file may point to the location used a non-Admin version of Designer even after the version of Designer changes to Admin. The .ini files installed by the Predictive Tools Download are listed below. Note there are separate lists for the non-Admin and Admin versions of Designer.   Admin version C:\Program Files\Alteryx\Settings\RPluginSettings.ini C:\Program Files\Alteryx\Settings\AdditionalPlugins\RPlugin.ini C:\Program Files\Alteryx\Settings\AddOnData\Macros\R-(version_number)_Macros.ini   Non-Admin version C:\Users\(user_name)\AppData\Local\Alteryx\Settings\RPluginSettings.ini C:\Users\(user_name)\AppData\Local\Alteryx\Settings\AdditionalPlugins\RPlugin.ini C:\Users\(user_name)\AppData\Local\Alteryx\Settings\AddOnData\Macros\R-(version_number)_Macros.ini   Check the folders containing the .ini files listed above to see if additional .ini files exist. If there are more .ini files, open each file and look for folder paths with an R folder such as R-(version_number) or R-library. If such as path exists in the file, then close it, and temporarily move the file to your Desktop. Then, close and re-open Designer and see if the missing tools appear. If the moved file is still needed (to run a custom tool, for example), edit it with the correct settings matching those found in the default files from the Predictive Tool Download, and then return the file to the original folder. For example, this is the correct location for the plug-in files used by an Admin version of Designer.   Here a fictitious example file that still has an R folder path for non-Admin version of Designer, even though the workstation has the Admin version. The file should be corrected or removed if obsolete.   Additional Resources   Troubleshooting Predictive Tools Installation  Installing two different versions of Alteryx on the same machine- with predictive tools  How to install the Microsoft R Client Predictive Tools     
View full article
How to install the Microsoft R Client Predictive Tools   Most people using Designer will only install the Alteryx Predictive Tools. These tools do not need additional software other than Designer. The Microsoft R Client Predictive Tools require a separate Microsoft R Client installation.   Prerequisites   An account with Windows Administrator privileges on the workstation for the installation Admin version of Designer   See the link below for the Alteryx Designer Predictive Tools Compatibility Policy.    Predictive Tools Compatibility Policy    Please complete the installation using the sequence listed below. When a different order of installation occurs, there may be errors such as Microsoft R Client was not found on this computer and is required for this install.   Admin privileges are required to install Microsoft R Client Predictive Tools, as some Windows components and drivers are part of the installation. These tools must be used with the Admin version of Designer.    Procedure   Go to downloads.alteryx.com. In the Product Downloads List, select the version of Designer or Server that will be used with the Predictive Tools.   Download and install Alteryx Designer or Server first.     In the Designer Product Download List at downloads.alteryx.com, choose the Alteryx Predictive tools that match the Designer version, and install these tools.   Next, the Microsoft R Client should be downloaded and installed. Download files and a compatibility chart for the correct version to use are available at Microsoft Machine Learning Server R Client.   The last software to install is in the first Other Predictive Tools section of the Designer downloads page, the Microsoft R Client Predictive Tools (MRCInstaller).   Additional Resources   Alteryx and Microsoft R Integration   What is Microsoft R Client  
View full article
With the Python Tool, Alteryx can manipulate your data using everyone’s favorite programming language - Python! Included with the tool are a few of pre-built libraries that extend past even the native Python download. This allows you to extend your data manipulation even further than one could ever imagine. The libraries installed are listed here - and below I’ll go into a bit more detail on what and why these libraries are so useful.   Each library is well documented, and there’s usually an introduction or examples on their sites to get you started on how a basic function in their library works.     ayx – Alteryx API – simply enough, we’re using Alteryx, sooo yea, kind of a requirement for the translation between Alteryx and Python.   jupyter – Jupyter metapackage – If you’ve used a Jupyter notebook in the past, you’ll notice the interface for the Python Tool is similar. This interface allows you to run sections of code outside of actually running the workflow, which makes understanding and testing your data that much easier. http://jupyter.org/index.html   matplotlib – Python plotting package – Any charting, plotting, or graphical needs you would want will be in this package. This provides a great deal of flexibility for whatever you want to visualize. https://matplotlib.org/   numPy – NumPy, array processing for numbers, strings, records, and objects – Native Python processes data in what some would call a cumbersome way. For instance, if you wanted to make a matrix, a.k.a. a 4x4 table, you would need to create a list within a list, which can slow processing a bit. However, NumPy has its own “array” type that fits the data in this matrix pattern that allows for faster processing. Additionally, it has a bunch of methods of handling numbers, strings, and objects that make processing a whole lot easier and a whole lot faster. http://www.numpy.org/   pandas – Powerful data structures for data analysis, time series, and statistics – This is your staple for handling data within Alteryx. Those who have used Python, but never pandas, will enter a whole new beautiful world of data handling and structure. Data manipulation within Python is faster, cleaner, and easier to code with. The best part about it is that the Python Tool will read in your Alteryx data as a pandas data frame! Understanding this library should be one of the first things to know when tackling the Python code. https://pandas.pydata.org/   geopandas – Extends the data types used by pandas to allow spatial operations on geometric types. Are you interested in geospatial analysis using Python? Try this package.  It makes working with geospatial data in Python much easier and faster.  http://geopandas.org/   requests – Python HTTP for Humans – for all the connector/Download Tool fans out there. If any of you are familiar with making HTTP requests (API calls and the like), then you should introduce yourselves to this package and explore how Python performs these requests. http://docs.python-requests.org/en/master/   scikit-learn – a set of Python modules for machine learning and data mining – Welcome to the world of machine learning in Python! This library is your go-to for statistical and predictive modeling and evaluation. Any crazy and wild methods you’ve learned for machine learning will most likely be found here and can really push the boundaries of data science. http://scikit-learn.org/stable/   scipy – Scientific Library for Python – all your scientific and technical computing can be found here. This library builds off the packages already installed here, like numPy, pandas, and matplotlib. Dealing with mathematical models and formulae are usually located within this library and can help provide that higher level analysis of your data. https://www.scipy.org/   six – Python 2 and 3 compatibility utilities – For those who are unfamiliar, Python versions come in 2 forms, version 2.x and 3.x (with 3.x being the most recent). Now, even though Python 3 is supposed to be the latest and greatest, there are still many users out there who prefer using Python 2. Therefore, integration between the two is a bit tricky with syntax differences, etc. The six module provides functions that are usable between the two so everyone can remain calm and happy! Their documentation is usually coupled with which version the functions most closely align to, so a user can get a better idea to its functionality. https://pypi.org/project/six/   SQLAlchemy – Database Abstraction Library – SQL in Python! Covers all your database needs from connecting to and extracting data, allowing it to interact with your Python code and thus, Alteryx itself. https://www.sqlalchemy.org/   statsmodels – statistical computations and models for Python – This library builds off sci-kit learn but focuses more on statistical tests and data exploration. Additionally, it utilizes R-style formulae with pandas data frames to fit models! https://www.statsmodels.org/stable/index.html   These are the libraries installed with the Python Tool, which can do almost any data function imaginable. Of course, if you’re looking to do something that these libraries don’t provide, there are myriad other Python libraries that I’m sure will help you with your use case. Most of these are also well documented in how to use so search away and let your mind float away in the beautiful cosmos created by Python.
View full article
K-Centroids Cluster Analysis: No valid fields were selected   When using the K-Centroids Cluster Analysis tool, you may see the following error message:   Tool #27: Tool #6: No valid fields were selected. Tool #41: Tool #6: No valid fields were selected.   Environment   Product - Alteryx Designer Predictive Tools   Cause   The most common cause for this error message is: One of the fields selected has no statistical variance (all values are the same) If this is the case, you will often see another error message stating: "One or more of the provided data columns has a single data value."   Solution   Attach a Field Summary tool (Data Investigation) to the data you are sending into the K-Centroids Cluster Analysis tool Investigate the results to find any fields no variance   Additional Resources Pre-Predictive: Using the Data Investigation Tools  
View full article
AlteryxRPluginEngine.dll could not be loaded: The specified procedure could not be found   When running any of the R-based predictive tools in Designer, you may come across the below error message:   AlteryxRPluginEngine.dll could not be loaded: The specified procedure could not be found. (127)   Environment   Product - Alteryx Predictive Tools Any R-based predictive tool (Linear Regression, Decision Tree, Association Analysis, etc.) Cause   Typically this error is caused by having a mismatch in versions between Designer and Predictive Tools. It is required that both Designer and Predictive Tools are on the same version number (e..g, 2018.4) and type (Admin/Non-Admin).   Solution   Search Windows for "Add or Remove Programs" or go there through the Control Panel Uninstall both Alteryx Designer and Alteryx Predictive Tools Note: It is fine to only uninstall either all Admin versions, or all Non-Admin versions, if desired. Non-Admin versions will say (User) in parentheses. Download the matching versions from the Downloads page Admin example:  AlteryxInstallx64_2019.3.5.17947.exe AND RInstaller_2019.3.5.17947.exe Non-Admin example: AlteryxNonAdminInstallx64_2019.3.5.17947.exe AND RNonAdminInstall_2019.3.5.17947.exe   Additional Resources   Alteryx Downloads
View full article
Unable to load the Rcpp package   When using the Predictive tools, you may get an error stating that the Rcpp package cannot be loaded, or that the namespace load failed.   Unable to load the Rcpp package - Use the R installer provided by Alteryx   Environment   Product - Alteryx Designer Predictive Tools   Cause   User-installed packages may have overwritten Alteryx's default Rcpp package or a mismatch between Designer and Predictive Tools version may have caused the Rcpp version to become out of sync with Designer. Other causes are possible as well.   Solution   Make a backup and delete the existing Rcpp package from the folder corresponding to your Designer version (Admin or non-Admin): Non-Admin: %LOCALAPPDATA%\Alteryx\R-{VERSION}\library\Rcpp Admin: C:\Program Files\Alteryx\R-{VERSION}\library\Rcpp Run the R terminal as Administrator: Non-Admin: %LOCALAPPDATA%\Alteryx\R-{VERSION}\bin\x64\Rterm.exe Admin: C:\Program Files\Alteryx\R-{VERSION}\bin\x64\Rterm.exe Re-install the Rcpp package with the following command:  install.packages("Rcpp", type="binary") Restart Designer and test the sample predictive workflows found under Help -> Sample Workflows If you continue to experience issues, open the R terminal again and run the command below. Provide any error message to Support to further troubleshoot. library(Rcpp)    
View full article
The TS Factory tools can build time series models and forecasts for multiple sets of historical data groups, without the need to separate them.  This is their relationship to the batch macro.
View full article