Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
New line (\n) inserted in a concatenated field cant be read by the Email Tool causing body of the email to appear as a single paragraph
View full article
Fixed decimals values in Alteryx results in Null values and report the following error: Input data (1):not a valid FixedDecimal. FixedDecimal values ​​must be of the form: -nnn.nn
View full article
Here is a simple tip to create a Text Input tool with multi-line records.
View full article
Troubleshooting instructions for the error The system cannot find the file specified when attempting to use a 32-bit database connection in the Input Data or Dynamic Input Tool.\n  
View full article
Alteryx can connect to databases using different methods. This guide will focus on setting up an OleDB connection to SQL server, however, the same general process can be followed to connect to any database via OleDB.
View full article
In relational databases a NULL value is used to represent a missing or unknown value in the column.
View full article
When opening a workflow file the below error occurs and the file does not open nor do autorecovered workflow copies open.
View full article
Even though the Spatial Match tool is extremely fast and efficient, there are additional ways its speed can be further improved. This article provides suggestions to increase performance.
View full article
How To: How Does Alteryx Handle Oracle Dates
View full article
Troubleshooting Invalid Path: "Cleanse.yxmc" / Nested Macro Locations are not supported
View full article
This error occurs when importing a Gallery Data Connection, but there is an issue with the Gallery Data Connection.
View full article
There is a comprehensive list of Data Sources Alteryx Designer / Server can connect to. While only these are supported you still might be able to build your own connector. Additionally a product feature can be requested.
View full article
Designer 2020.2 introduces AMP Engine. In many use cases AMP will be faster than the older e1 Engine. However, this article will give some guidance on when to use AMP.
View full article
In many cases the IT department might insist on implementing rotating passwords as a security measure. How can this be achieved in Designer and Server for database connections?
View full article
This is a generic timeout error message. This article will shed further light on it.
View full article
Support policy for CReW Macros.
View full article
In some cases the Python tool will not start. This article discusses the common root cause that during installation there was not enough disk space for all the Python environment files to be created.
View full article
This error may be resolved with anti-virus settings, reinstallation, or if needed, use of the 1.09 version.
View full article
This article elucidates the Support offering available for Udacity (education) license users.
View full article
This is article will show you the "DataWrap2WrigleyDb::GoRecord: Attempt to seek past the end of the file" error and how to solve it.
View full article