Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
The Visual Query Builder is not displaying the table columns for PostgreSQL connection.
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
If the workflow path contains a "&", Python tool will fail to load. 404: Not Found will be seen.
View full article
All levels of logging (warning, error, debug, info, etc) is treated as an error and return as an error in Production mode of Python tool.
View full article
An error is thrown when scheduling a workflow in Desktop Scheduler in a non-English language. This only occurs with the 'Custom' option under Frequency.
View full article
"Error (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170) " when using HIVE ODBC Connection
View full article
So, you are new to Alteryx and you find an administrator version, non-administrator, licenses, predictive tools ... Do not worry, in this guide I will describe step by step the procedure to install Alteryx Designer on your computer. If you require something specific, here is the content of the guide so you can get to what you are looking for faster.
View full article
Error "ora-28094: SQL Construct Not Supported by Data Redaction" when trying to test sql query - basic select * from objectname
View full article
Error: "An item with the same key has already been added" when selecting Oracle Quick Connect
View full article
Incorrect number of records being read from an Oracle database. Alteryx appears to be adding 100 duplicate rows
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
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
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.
View full article
This article addresses the replacement of PDF Input tool with the Image Input tool starting from 21.2 version of Alteryx Designer
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
View full article
Designer crashes when a forward slash (/) is used in the Output Name field of the Macro Output tool.
View full article
Where do you start when you see "An Unhandled Exception occurred"?
View full article