Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

When trying to read data from Hive, the error: "SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis" is thrown in the server while executing a query.
View full article
Support policy for CReW Macros.
View full article
This error is usually caused by two things: The file you selected is of a differentformat than what is selected in the File Format drop down in the Configuration window. A .yxdb file you are using as an input has become corrupt. Other causes can be found here:https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Error-FileID-does-not-match-in-the-FileHeader/ta-p/19870 Although extremely rare, if a .yxdb file becoming corrupt is the culprit (one cause is a network connection dropping in the middle of writing the file), you may have a quick and simple way to resolve this potentially stomach-dropping issue: Open up Windows Explorer and navigate to the file. Right-click on the file and choose Properties. Click on the Previous Versions tab. If you're lucky, there isat least one option of the file that you can revert back to you, hopefully allowing you to avert disaster. Obviously, this doesn't just work with Alteryx files, so perhaps this knowledge will come in handy with other files. Thanks for reading!
View full article
Error: "Cursors are not supported" or "Cursor support is not an implemented feature" when running a workflow against SQL Server or Azure Synapse.
View full article
When ruining a workflow, the Designer throws the message: "The workflow contains unlicensed tools"
View full article
Steps on how to reinstall a Python-based .yxi tool.
View full article
If you have installed a Designer 2020.2 and later (along with having an active license for them) but the Intelligence suite tools seem to be missing you can follow these steps to reinstall them.
View full article
This KB explains how to query views with the Google BigQuery Input Tool
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
Users can experience this error message upon opening Alteryx Designer or upon select the File menu option.
View full article
How to install two versions of Designer on the same machine.
View full article
Error: "There were errors with LOADING please check your ERROR TABLES", when writing data using Output Data tool to Teradata.
View full article
Reading and Writing spatial data from/to Redshift
View full article
How to connect to SQL Server Analysis Services (SSAS) and extract data in Alteryx Designer.
View full article
When utilizing the new PostgreSQL bulk loader to write to the database you get an error.
View full article
Here is a list of items that we suggest get whitelisted for antivirus software to reduce unexpected behavior.
View full article
The message, "Error while trying to retrieve text for error ORA-12705" occurs when using multiple IN-DB tools to different Oracle connections.
View full article
This issue appears when an App writes to an Excel document. When the results are displayed and the Excel document opened, it will show as empty. As soon as the Excel document is closed, an Unhandled exception error will display, and the App cannot be closed.
View full article
Robocopy is a robust Windows Command Prompt utility for copying files from one location to another. Unfortunately, it uses exit code 1 to indicate success which Alteryx interprets as an error.
View full article