Alteryx Designer Knowledge Base

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.

Visual Query Editor: 3 dots Buttons don't do anything

Unhandled Exception when clicking on the Browse Tool when using an R and Cross Tab in the workflow

SMTP settings of the most common email providers for configuration in the Email Tool and Email Events.

Troubleshooting Parse Error at char(n): Empty expression (Expression #n)

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.

Spatial Data from SQL Server shows up as "None", "Null", or other characters in the Input Data tool.

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.

A quick reference guide that will help you prepare two different data sources for use with Fuzzy Match Merge Mode

This article covers how to use Run Command events to run a workflow.

How to format common ODBC DSN-less connection strings

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.

Failed to find virtual env named: “designerbasetools_venv” occurs if the Server version is on a lower minor version than the Designer.

After an upgrade of the Simba Hive driver to 2.6.10 in-DB workflows might fail.

Error: "Query timeout" when running a workflow connected to Amazon Athena.

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.

Error even though the table has a Primary Key

 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.

This article will walk through how to have different Module versions for different workflows. This example will use PyPDF2 as the Module

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.

Python tool doesn't show any results.