Alteryx Designer Desktop Knowledge Base

Characters that are not on a standard English keyboard may need translation into Unicode or a language-specific code page for Designer and database drivers to read them correctly. Characters with incorrect encoding will often appear as boxes or question marks in the Designer Results screen and error messages. Unicode characters take more bytes than English ASCII characters. Changing the column type and increasing the column size may be needed. In Designer, the column size is the number of characters, not the number of bytes.

When attempting to publish a workflow to your private Gallery which contains the Publish to Tableau Server macro, you may encounter an error similar to this: “Cannot find macro "PublishToTableauServer_v1.08.1\Publish to Tableau Server.yxmc"

Within Alteryx there isn't an output option directly to a text file. To achieve this you will need to use a flat ASCII file.

Error: "Cursors are not supported" or "Cursor support is not an implemented feature" when running a workflow against SQL Server or Azure Synapse.

Not able to select a different database for existing Gallery connections for SQL Server within Designer.

Not able to clear the connection string history. There is no option or button to clear it.

Troubleshooting the error: You must specify a sheet name.

Is it possible to change a Qlikview Dashboard to Tableau using Alteryx?

What is the delimiter when writing In-DB via HDFSC

How to download and install SQL Server ODBC drivers.

Error: "ORA-12170: TNS:Connect timeout occurred" when running a workflow.

How do I identify the column(s) responsible for the SQL Server error, “String or binary data would be truncated”.

Error: "Incompatible with the Client software" when connecting to Teradata in Designer

Error: "Unsupported data type 'bit'", when writing data with a Boolean to Snowflake.

Error: "Login failed for user ' '" when connecting to SQL Server with Azure Active Directory.

Receiving timeout errors when attempting to use the MultiSubnetFailover=true parameter in a SQL Server Availability Group with a multi-subnet listener.

Error: "There were errors with LOADING please check your ERROR TABLES", when writing data using Output Data tool to Teradata.

Error: "ORA-00900: invalid SQL Statement" occurs when running a procedure in the Pre or Post SQL Statement for Input or Output Data tools.

Snowflake External Tables are not showing in the Alteryx Visual Query Builder tab.

Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone.

Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.