Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.
View full article
Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.
View full article
Python tool will not load Jupyter Notebook if the Detour tool is used and the path is diverted to another path where the Python tool is not on by default.
View full article
Installing a package from the Python tool is an important task. In this article, we will review all the possible functionality included with the Python method Alteryx.installPackages().
View full article
When trying to license Alteryx Server on a Windows 8 based computer , the user receives the error "An internet connection is required for activation. Please connect to the internet and try again, or contact customer support. Contact your license administrator for help with licensing. Defect TCPE-196
View full article
XML Parse tool does not detect specific child
View full article
Alteryx.read() returns "attempt to seek past the end of the file" on an empty incoming data source
View full article
When trying to connect to your working Designer's Scheduler, you are getting the error "machine-name" is not an active controller
View full article
When user tries to input CSV file that has delimiter character encapsulated in quotes (so that it should not be considered a delimiter), connector will not consider the file valid.
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
When trying to add a license key to Alteryx License Server an error - The System cannot find the file specified - may be seen if the password contains a pipe character |
View full article
Platform Product: Designer Issues – Working with Alteryx Customer Support Engineers (CSEs)
View full article
The Join Multiple tool does not work as expected when the ‘Use AMP Engine’ setting is checked.
View full article
Making a copy of a workflow that contains a Python tool will cause the JupyterGuidDir to be duplicated. Because of this reason, both copies will point to the same Jupyter Notebook document. If the user makes changes on one copy, the other will be changed too which is not desirable.
View full article
Alteryx is upgrading our embedded Python version shipped with our latest 2020.4 release. This article will cover how this will impact tools developed with the Python SDK.
View full article
Learn about the new 20.4 changes to Python.
View full article
How to enable Jupyter Server log which is no longer created by default in 2020.1.
View full article