Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Note: Alteryx Community may experience brief downtime during 12a-4a PT hours. We apologize for any inconvenience.
How to download and install SQL Server ODBC drivers.
View full article
Where do you start when you see "An Unhandled Exception occurred"?
View full article
The SharePoint List Output tool cannot write to metadata columns. This capability will be added in a future release.
View full article
Designer requires .NET version 4.7 or newer to use the TLS 1.1 or 1.2 protocols. For workstations with Windows 7, other configurations are also needed.
View full article
Data Cleansing tool doesn't work in 2020.4 when the Field name contains line breaks unix style line endings.
View full article
When installing alteryx, the installer gets stuck on the python dependency window
View full article
XML Parse tool does not detect specific child
View full article
SMTP fails in Email tool. The error "Record#1: Unable to create a socket after looping through all network addresses for YOUR-MAIL-HOST-NAME" is returned.
View full article
Some of the tools Alteryx Designer uses require proxy to be enabled and setup. This document will advise how to check if a proxy exists on a system.
View full article
When running a workflow that uses a RegEx tool ahead of a Select Record tool, you receive different results with or without uding the Use AMP Engine.
View full article
This error is displayed on current workflows with R and then if you put a new R tool on a blank canvas
View full article
Display issues when reading data with unicode characters from Oracle
View full article
When publishing a workflow to Gallery or Scheduler (Designer + Desktop Automation) or when packaging a workflow for export, checking the boxes for what to include and what to exclude seems to work inconsistently as of Designer 2020.2. Here is a workaround to cover you until the issue is resolved in a future release.
View full article
User is getting the error "Detour tools in macros must terminate within that macro" when trying to use a macro in a workflow
View full article
A workflow that includes a Python tool may throw an error of the form "Error: unable to read data (C:\AppData\Alteryx\Engine\Engine_23200_be6a9480b4fc4e038a8668b82debdf74_\aa37b5ac-6323-472b-8f0f-5cb0b95b822e\4460abb7be83bae8f01b9bf1238a923c.yxdb)"
View full article
This error may occur with Desktop Automation schedules. It can be corrected by changing the Alteryx Service log on account.
View full article
This error occurs when a transaction limit is exceeded. It can be resolved by configuring bulk uploads on the server or using an iterative macro.
View full article
Workflow worked in versions before 2020.3 After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord"
View full article
In some cases the Python tool will not start. This article discusses the common root cause that during installation there was not enough disk space for all the Python environment files to be created.
View full article
Learn about the new 20.4 changes to Python.
View full article
When trying to read data from Hive, the error: "SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis" is thrown in the server while executing a query.
View full article