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.
This article will review how to install and uninstall Python packages without using the command prompt or the built in installPackages method. This method will also provide better messages if something does error out.
View full article
Unhandled Exception when clicking on the Browse Tool when using an R and Cross Tab in the workflow
View full article
SMTP settings of the most common email providers for configuration in the Email Tool and Email Events.
View full article
Troubleshooting Parse Error at char(n): Empty expression (Expression #n)
View full article
Making a copy of a workflow that contains a Python tool will cause the JupyterGuidDir to be duplicated. Because of this reason, both copies will point to the same Jupyter Notebook document. If the user makes changes on one copy, the other will be changed too which is not desirable.
View full article
Spatial Data from SQL Server shows up as "None", "Null", or other characters in the Input Data tool.
View full article
This article will review the method of creating a requirements text file that can be used to reinstall the same packages. Then a process to reinstall the same packages.
View full article
A quick reference guide that will help you prepare two different data sources for use with Fuzzy Match Merge Mode
View full article
This article covers how to use Run Command events to run a workflow.
View full article
How to format common ODBC DSN-less connection strings
View full article
When using Excel spreadsheets in Alteryx, sometimes there may be difficulty in reading the data. Viewing the spreadsheets in XML format is an excellent way to check for encoding or formatting issues.
View full article
Failed to find virtual env named: “designerbasetools_venv” occurs if the Server version is on a lower minor version than the Designer.
View full article
Error: "Query timeout" when running a workflow connected to Amazon Athena.
View full article
Stored Procedures are powerful and helpful, however, in Designer and Server it is required for them to have a return value. If that is not the case the error "no columns returned" will occur.
View full article
 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
This article will walk through how to have different Module versions for different workflows. This example will use PyPDF2 as the Module
View full article
If you have installed a Designer 2020.2 and later (along with having an active license for them) but the Intelligence suite tools seem to be missing you can follow these steps to reinstall them.
View full article