Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
Welcome to the addictive world of predictive analytics. We have the perfect platform for you to start exploring your data.
View full article
If there is a space in the temporary directory, Predictive tools in Data Investigation, Predictive and Time Series and even R tool fail with errors like the following: Error in parse(text - 5): :1:17:unexpected INCOMPLETE_STRING
View full article
When connecting to Databricks and querying long text fields, the data being returned is truncated to 254 characters.
View full article
Uploading duplicate data using Postgres Bulk Update reports as successful, when the update has actually failed with a unique constraint violation error.
View full article
Welcome to Part 2 of the Pre-Predictive series! After a strong start but long hiatus, we will be resuming our tour of the Data Investigation Tools. This section will cover the Frequency Table, Contingency Table and Distribution Analysis Tools.
View full article
Welcome to Part 3 (out of 4) of the Pre-Predictive series. In this article series, we are introducing you to the very exciting world of data investigation. This section covers the Association Analysis Tool, The Pearson Correlation Tool, and the Spearman Correlation Tool!
View full article
Welcome to the closing chapter of our voyage through the Pre-Predictive series! This has been a four-part journey introducing you to the thrilling world of data investigation. This section covers the plotting tools included in the Data Investigation Toolbox.
View full article
Time series forecasting is using a model to predict future values based on previously observed values. In a time series forecast, the prediction is based on history and we are assuming the future will resemble the past. We project current trends using existing data.
View full article
Check out the Predictive District on the Gallery. There are great macros, apps, and sample workflows to demonstrate some nifty new tools.
View full article
Characters that are not on a standard English keyboard may need translation into Unicode or a language-specific code page for Designer and database drivers to read them correctly. Characters with incorrect encoding will often appear as boxes or question marks in the Designer Results screen and error messages. Unicode characters take more bytes than English ASCII characters. Changing the column type and increasing the column size may be needed. In Designer, the column size is the number of characters, not the number of bytes.
View full article
This error occurs when the validation sample contains inconsistent data with the evaluation sample causing different data types for the same column.
View full article
This article was put together to resolve a common issue with cleansing your data as well as to show the use of tools and techniques that are not normally used for newer users. The goal of the article is to get newer users into these tools to open their creativity with the tool and hopefully take you to the next level!   In this use case, the data in the attached workflow is messy with capitalized strings all over the place. We want to format the data by removing some of the capitalization, but not all of it.   Note: If we wanted to make every first letter of the word capitalized we can use the Formula Tool and the TitleCase(String) function. This would make BEAR the WEIGHT - Bear The Weight. See the difference?   Example:   The tools that we will be using in this exercise is the Record ID, Text to Columns, RegEx, Formula, Tile, and Cross Tab Tools.     The exercise will show you the importance of using the Record ID Tool. The flexibility of the Text to Columns and RegEx Tools, the under-used Tile Tool, the creativity of the Formula Tool, and the not so scary Cross Tab tool when then data is configured properly.   We hope that these exercise and use cases open up your mind and the greatness of Alteryx!   See attached workflow and enjoy!
View full article
The cause and solution to the "DisableAllOutputForLicense" error with the Predictive Tools.
View full article