We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Error: "Test Query Error near 'as': syntax error" when executing a 'WITH' clause against a SQLITE table
View full article
How to fix an issue where the Python Tool Configuration Panel is blank
View full article
Uploading duplicate data using Postgres Bulk Update reports as successful, when the update has actually failed with a unique constraint violation error.
View full article
This article discusses how to fix the Onload failed in loadNamespace error experienced when users have issues associated with predictive tools that make use of the pdftools package
View full article
When troubleshooting Python Issues in Alteryx, this Health Check can be used to determine whether your Jupyter Environment installation is complete and functional.
View full article
When outputting to Oracle, the Designer result panel shows ORA-00001: unique constraint violated.
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. The workaround will tide you over until you can upgrade to 2021.2.
View full article
Creating a new date field based on a formula
View full article
Receive "ERROR: The session is read-only" using pre/post SQL option in the Input Data tool when attempting to perform any operation that is not a select statement, such as dropping/creating tables
View full article
Error "Timestamp is not close enough to the current server time" when running a workflow that contains an Oauth Macro in Alteryx Designer.
View full article
This KB is extracted from the Inspire 2019 Tips + Tricks and outlines how to connect to a document library (Sharepoint) via Alteryx.
View full article
AlteryxRPluginEngine.dll could not be loaded: The specified procedure could not be found
View full article
Snowflake Connection Failure - Error SQLDriverConnect:[Snowflake][Snowflake] (4) REST request for URL xxxxxx failed: CURLerror (curl_easy_perform() failed) – code=6 msg=’Couldn’t resolve host name
View full article
AlteryxSpatialPluginsEngine.dll could not be loaded: The specified module could not be found
View full article
When the client has multiple browser sessions open with anything connecting to the gallery, it might cause an invalid session error when uploading a workflow to the Gallery.
View full article
The Run Button, Schedule Button, and the active document buttons disappear from Designer when you make the configuration pane or Result pane a tabbed document
View full article
Error: "Cannot find data type 'ntext'" when writing data to Azure SQL database.
View full article
Troubleshooting Database Connections
View full article
How to Sort with IN-Database tools
View full article
This article provides answers the most frequently asked questions related to In-Database Tools.
View full article