Alteryx Designer Knowledge Base

Not displaying the list of workflow assets.

The Visual Query Builder is not displaying the table columns for PostgreSQL connection.

This article details on the steps to read/extract password protected excel file in Alteryx Designer using the R code.

If the workflow path contains a "&", Python tool will fail to load. 404: Not Found will be seen.

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.

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.

"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

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.

Error "ora-28094: SQL Construct Not Supported by Data Redaction" when trying to test sql query - basic select * from objectname

Error: "An item with the same key has already been added" when selecting Oracle Quick Connect

Incorrect number of records being read from an Oracle database. Alteryx appears to be adding 100 duplicate rows

When outputting to Oracle, the Designer result panel shows ORA-00001: unique constraint violated.

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.

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

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.

This article addresses the replacement of PDF Input tool with the Image Input tool starting from 21.2 version of Alteryx Designer

Unable to connect to Hadoop Impala when using Kerberos Authentication type

How to collect Wireshark traces to troubleshoot network-related issues.

Designer crashes when a forward slash (/) is used in the Output Name field of the Macro Output tool.

Where do you start when you see "An Unhandled Exception occurred"?

Compliance with FIPS Cryptography