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.
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
This article details on the steps to read/extract password protected excel file in Alteryx Designer using the R code.
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
Received the error "Error in PDF Rendering. Error Number: 4119: FILE OPEN ERROR" whenever using Table Tool or Render Tool.
View full article
Error: Can’t find the file: “[path\FileName]”. Make sure the file path is correct. Error text being revised from Error: File not found "[path\FileName]"
View full article
Unhandled Exception when clicking on the Browse Tool when using an R and Cross Tab in the workflow
View full article
Error while installing additional R packages in Alteryx Designer - "GenericTool (1): Can't find plugin "AlteryxRPluginEngine.dll""
View full article
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