Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

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
When ruining a workflow, the Designer throws the message: "The workflow contains unlicensed tools"
View full article
Alteryx is upgrading our embedded Python version shipped with our latest 2020.4 release. This article will cover how this will impact tools developed with the Python SDK.
View full article
Learn about the new 20.4 changes to Python.
View full article
Users can experience this error message upon opening Alteryx Designer or upon select the File menu option.
View full article
Robocopy is a robust Windows Command Prompt utility for copying files from one location to another. Unfortunately, it uses exit code 1 to indicate success which Alteryx interprets as an error.
View full article
Alteryx doesn't read some unicode characters correctly
View full article
Procedures on how to configure Designer for input of large, zipped text files for processing.
View full article
User is getting an error writing an excel file to a shared drive.
View full article
Very rarely Designer can crash with a big red X across a window. One such situation has been observed and resolved.
View full article
Calgary Loader (2) PagedFile::Add: keys out of order, sort not supported yet.
View full article
Troubleshooting the "Unknown Function YEAR()" error, or other related Date expressions.
View full article
Error while connecting to MySQL, from the Input Data Tool - Error: Input Data (13): Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
View full article
This article explains how to run workflows referencing excel files that are open by another user. This can be a requirement where multiple users are using the same file to update information
View full article
While trying to connect to Snowflake from Alteryx Designer, using Input Data tool, the following error is thrown after running the workflow: Error: Input Data (1): Error SQLExecute: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
View full article
Some Salesforce users do not use Salesforce Security Tokens. An accepted IP range can be set up instead in Salesforce Admin. This article will walk you through the steps to modify the Salesforce Output tool to be able to be used without a Salesforce Security Token.
View full article
For problems with Windows not launching Designer or displaying an error message, the Program Compatibility Troubleshooter may help.
View full article
Data preparation and investigation are a must for successful Predictive Modeling.
View full article