Alteryx Designer Knowledge Base

How To: Create an In-Database Connection

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.

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.

Environment variable issue with the os.environ['PATH'] error

Text Mining Tool FAQ

Data types W_String or VW_String are not available for Flat File ASCII files.

Tableau Function Translation Guide

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.

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.

Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool.

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

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.

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.

Where do you start when you see "An Unhandled Exception occurred"?

This KB is extracted from the Inspire 2019 Tips + Tricks and outlines how to connect to a document library (Sharepoint) via Alteryx.

An Unhandled Exception occurred when opening a workflow

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.

Error reading CSV files using AMP Engine

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.

This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.

Error: "You have found a bug. Replicate, then let us know. We shall fix it soon." when pulling data from Snowflake.