Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Display issues when reading data with unicode characters from Oracle
View full article
Error: "Must declare the scalar variable '@var_name'" when running PL/SQL in Pre or Post SQL Statement Section.
View full article
This KB outlines the workaround for DE18888 where Cyrillic characters from DB2 are not displaying in Designer
View full article
Learn about upcoming changes to Alteryx support of 32-bit database connections and start planning today
View full article
Error: "Login failed for user ' '" when connecting to SQL Server with Azure Active Directory.
View full article
Here we’ll delve into uses of the Text Input Tool on our way to mastering the Alteryx Designer:
View full article
Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.
View full article
Querying a date from the Alteryx Server Persistence MongoDB using the MongoDB Input tool can be tricky since Alteryx Server dates are stored as string values. Here is how to use regex in the criteria section of the MongoDB Input tool.
View full article
Receiving timeout errors when attempting to use the MultiSubnetFailover=true parameter in a SQL Server Availability Group with a multi-subnet listener.
View full article
Error: "CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error'." when connecting to Snowflake.
View full article
User gets a Win32 Exception when trying to connect to a database or edit a query
View full article
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
This error is usually caused by two things: The file you selected is of a differentformat than what is selected in the File Format drop down in the Configuration window. A .yxdb file you are using as an input has become corrupt. Other causes can be found here:https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Error-FileID-does-not-match-in-the-FileHeader/ta-p/19870 Although extremely rare, if a .yxdb file becoming corrupt is the culprit (one cause is a network connection dropping in the middle of writing the file), you may have a quick and simple way to resolve this potentially stomach-dropping issue: Open up Windows Explorer and navigate to the file. Right-click on the file and choose Properties. Click on the Previous Versions tab. If you're lucky, there isat least one option of the file that you can revert back to you, hopefully allowing you to avert disaster. Obviously, this doesn't just work with Alteryx files, so perhaps this knowledge will come in handy with other files. Thanks for reading!
View full article
Error: "Cursors are not supported" or "Cursor support is not an implemented feature" when running a workflow against SQL Server or Azure Synapse.
View full article
This KB explains how to query views with the Google BigQuery Input Tool
View full article
Reading and Writing spatial data from/to Redshift
View full article
How to connect to SQL Server Analysis Services (SSAS) and extract data in Alteryx Designer.
View full article
Error: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections.
View full article
Alteryx doesn't read some unicode characters correctly
View full article
Fixed decimals values in Alteryx results in Null values and report the following error: Input data (1):not a valid FixedDecimal. FixedDecimal values ​​must be of the form: -nnn.nn
View full article
For most tools that already have “dynamic” in the name, it would be redundant to call them one of the most dynamic tools in the Designer. That’s not the case for Dynamic Input. With basic configuration, the Dynamic Input Tool allows you to specify a template (this can be a file or database table) and input any number of tables that match that template format (shape/schema) by reading in a list of other sources or modifying SQL queries. This is especially useful for periodic data sets, but the use of the tool goes far beyond its basic configuration. To aid in your data blending, we’ve gone ahead and cataloged a handful of uses that make the Dynamic Input Tool so versatile:
View full article