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!

This is a generic timeout error message. This article will shed further light on it.
View full article
Error: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections.
View full article
Alteryx doesn't read some unicode characters correctly
View full article
Procedures on how to configure Designer for input of large, zipped text files for processing.
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
For most tools that already have “dynamic” in the name, it would be redundant to call them one of the most dynamic tools in the Designer. That’s not the case for Dynamic Input. With basic configuration, the Dynamic Input Tool allows you to specify a template (this can be a file or database table) and input any number of tables that match that template format (shape/schema) by reading in a list of other sources or modifying SQL queries. This is especially useful for periodic data sets, but the use of the tool goes far beyond its basic configuration. To aid in your data blending, we’ve gone ahead and cataloged a handful of uses that make the Dynamic Input Tool so versatile:
View full article
Error: "ORA-00900: invalid SQL Statement" occurs when running a procedure in the Pre or Post SQL Statement for Input or Output Data tools.
View full article
Data blending, transformation and cleansing..oh my! Whether you're looking to apply a mathematical formula to your numeric data, perform string operations on your text fields (like removing unwanted characters), or aggregate your spatial data (among many other things!), the Formula Tool is the place to start.  With the examples provided below, you should be on your way to harnessing the many functions of the Formula Tool:
View full article
This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Input Data Tool on our way to mastering the Alteryx Designer
View full article
User is getting an error with Union In-DB tool: Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException Schema of both sides of union should match.
View full article
If you haven’t used the Run Command Tool just yet, that’s great. It means that whatever your analyses required, we had it covered with basic Designer functionality. But in spite of how great the Designer is, it just can’t do everything. There is a utility on your computer that can do just about anything, however, and it’s the command line. The Run Command Tool pairs the two into a dynamic tag-team duo that can wrestle all the computation you could need into one, integrated, Designer workflow:
View full article
User is getting an error writing an excel file to a shared drive.
View full article
Very rarely Designer can crash with a big red X across a window. One such situation has been observed and resolved.
View full article
This article covers how to use Run Command events to run a workflow.
View full article
The Append Fields tool adds every row of the source input to every row of the target input as new columns. This is also known as a Cartesian or cross join!
View full article
With the release of 2018.3 comes the long-awaited and highly anticipated Python Tool! This article is a general introduction to using the tool.
View full article
Calgary Loader (2) PagedFile::Add: keys out of order, sort not supported yet.
View full article
The Join Multiple tool is a combination of the Join and Union tool. It is best used to consolidate a workflow into one tool when you would instead use Multiple Join then Union tools.
View full article