We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Error: "Windows Security patch prevents the Jet driver from reading .xls files; install the 2010 32-bit Access driver" when loading an Excel .xls file
View full article
API connections give access to many web-based applications, database systems, or programs by exposing objects or actions to a developer in an abstracted format that can easily be integrated into another program.
View full article
The ODBC connection error "Netsuite ODBC Connection Error "[NetSuite][ODBC 64bit driver][OpenAcess SDK SQL Engine]You have entered an invalid e-mail address, password or context (AccountID, RoleID) information" occurs when connecting to NetSuite via a Input Data tool.
View full article
When accessing the MongoDB that is backing the Alteryx server using the MongoDB Input tool reading in AS_Schedules, AS_Queue, AS_Applications, AS_Results collections for analysis in a workflow, it throws the error "MongoDB Input: cursor id not found: generic server error" for larger collections
View full article
How Alteryx Designer and Server use file paths
View full article
Connector tools that use "Sign in via Internet Browser" do not work correctly with Designer or Server 2021.3.2. To use those tools, you should upgrade to version 2021.3.3 or later and then download and install the tool version that says " Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 21.3.3.63061 or later.." Alternatively in the short term, you can use version 2021.3.1 of Designer or Server.
View full article
When using special charater "≥" value in a database Input Data tool, the field displays as "=".
View full article
Nothing happens when clicking on the Save button when manually creating a connection string.
View full article
Error: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections.
View full article
Platform Product: Designer Issues – Working with Alteryx Customer Support Engineers (CSEs)
View full article
User is attempting to connect to Hadoop Hive with Kerberos in Alteryx and getting an error: Failed to get username: Routine Error: Unspecified GSS failure. Minor code may provide more information. The test button in the ODBC DSN is successful.
View full article
"I have a bajillion files that I need to bring into my workflow... wayyyyyy too many for me to use individual Input Data tools! What's the best way to do this?"                    - every Alteryx user ever
View full article
Error opening "SHOW VARIABLES LIKE 'aurora_version'" when connecting to MariaDB via ODBC.
View full article
If a column name contains brackets, the search function in the results panel would fail.
View full article
The Visual Query Builder is not displaying the table columns for PostgreSQL connection.
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
Using SQL Server connections, "date" datatype fields are changed to "V_WString"
View full article
Error: "Test Query Error near 'as': syntax error" when executing a 'WITH' clause against a SQLITE table
View full article
When outputting to Oracle, the Designer result panel shows ORA-00001: unique constraint violated.
View full article