Alteryx Designer

Definitive answers from Designer experts.
Numeric values show "[Null]" instead of a blank cell using the Input Data tool.
View full article
Error: "ORA-00900: invalid SQL Statement" occurs when running a procedure in the Pre or Post SQL Statement for Input or Output Data tools.
View full article
Error: "SQL30082N Security processing failed with reason "15" ('PROCESSING FAILURE')" when connecting to DB2 using the Input Data tool.
View full article
How To: Create an In-Database Connection
View full article
Importing Thai data from Oracle Database using Oracle ODBC driver is displaying the Thai characters as garbled characters in Alteryx. This can be addressed by setting a parameter in the driver to unconditionally change the data type to support Unicode.
View full article
Data types W_String or VW_String are not available for Flat File ASCII files.
View full article
Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool.
View full article
User is attempting to connect to Hadoop Hive with Active Directory Kerberos (Kerberos SSPI) 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
This KB is extracted from the Inspire 2019 Tips + Tricks and outlines how to connect to a document library (Sharepoint) via Alteryx.
View full article
When using Excel spreadsheets in Alteryx, sometimes there may be difficulty in reading the data. Viewing the spreadsheets in XML format is an excellent way to check for encoding or formatting issues.
View full article
Error: "You have found a bug. Replicate, then let us know. We shall fix it soon." when pulling data from Snowflake.
View full article
When importing data from an SAP HANA database, a conversion error from VARCHAR1 to ASCII may occur. 
View full article
Connecting to an Oracle APPS schema causes Designer to get stuck in "Not Responding".
View full article
Error: "CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error'." when connecting to Snowflake.
View full article
Connecting to Google Analytics is becoming more and more popular. There are a few things you need in order to use the Google Analytics macro; a Google Account (e.g., Gmail) and authorized access to an existing Google Analytics account. This article will help you get the rest of the way.
View full article
Error: "An Item with the Same Key has already been added" with Sharepoint List Input Tool
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: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.
View full article
Error: "Oracle driver: You are not licensed to use this DataDirect Technologies product" when connecting to Oracle in Designer.
View full article
Not able to clear the In-DB connection string history. There is no option or button to clear it.
View full article