Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
How To: Create an In-Database Connection
View full article
When starting Alteryx Designer the below error is received: There was an error while loading: Object reference not set to an instance of an object.
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
Environment variable issue with the os.environ['PATH'] error
View full article
Data types W_String or VW_String are not available for Flat File ASCII files.
View full article
Tableau Function Translation Guide
View full article
Customers using pre 2019.4 Designer and Insights Data need to update to the Mapbox maps or they will see this issue with Digital Globe maps.
View full article
In life, there are few things black and white. There are gray areas everywhere and the lines that separate can be a little fuzzy. The same holds true for data – especially when it’s human entered. That’s why we have the Fuzzy Match Tool – if your data isn’t clear as day, you can still get value out of your records by matching them to something a little more standardized.
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
Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone.
View full article
Understanding Join output anchors and when to add a Union tool:  The Join tool anchors are separate subsets of data. You can combine them with a Union tool. The Select functionality of the Join tool applies only to the J anchor, not the R or L anchored data.
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
Where do you start when you see "An Unhandled Exception occurred"?
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
An Unhandled Exception occurred when opening a workflow
View full article
Joining fields with name changes and reordering can be tricky. It's important that the data from Join tool anchors have field names that allow the Union tool to stack the data appropriately.
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
This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.
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