Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Error: "An Item with the Same Key has already been added" with Sharepoint List Input Tool
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
"I have a bajillion files that I need to bring into my workflow... wayyyyyy too many for me to use individual Input Data tools! What's the best way to do this?"                    - every Alteryx user ever
View full article
Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.
View full article
This article will walk through how to enable to Google Analytics APIs to be used in the Google Analytics Connector with OAuth2 login option
View full article
Errors and warnings occur when predictive model names contain spaces
View full article
An "Unhandled Exception" thrown when starting Designer, appears when the user clicks on the splash screen. Looking at C:\ProgramData\Alteryx\ErrorLogs reveals the following error type: System.IO.DirectoryNotFoundException Message: Could not find a part of the path 'F:\.....'
View full article
The error message appears when using System Settings in Alteryx Designer.
View full article
How to Resolve display issues in Designer
View full article
In some cases Designer is very slow when working from home. This can have several root causes.
View full article
Alteryx has the ability to connect with MIT Kerberos and Active Directory (Kerberos SSPI) based Hadoop implementations. With this feature came the need to tell the driver that you are using Windows Kerberos/Kerberos SSPI and not MIT's version.
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
Data preparation and investigation are a must for successful Predictive Modeling.
View full article
This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.
View full article
An ETS model, otherwise known as exponential smoothing, estimates single variable forecasts using weighted averages of past observations. There is more weight given to recent observations with a gradual and constant rate of decrease for the observation weight over time. Depending on the method used, there is a smoothing equation for one or more of the following: level, trend, and seasonality.
View full article
Latest versions of the Google Sheets and Google Analytics Connectors introduce ability to share a Connection Token across tools helping to stay under refresh token limit
View full article
Date/Time data can appear in your data in string formats (text fields) or date formats. The DateTime Tool standardizes and formats such data so that it can be used in expressions and functions from the Formula or Filter Tools (e.g. calculating the number of days that have elapsed since a start date). It can also be used to convert dates in datetime format to strings to use for reporting purposes.
View full article
If you observe an error message like Error: Salesforce Input (1) File " ", line 1 os.environ['PATH'] = r"... please read on to learn how to adjust the environment variables to resolve it. This can happen with any one of several Connector tools, not just the tool mentioned in the example.
View full article
When developing an Analytic App, you can use .yxwv files to quickly populate your Analytic App with values.  This can be a real time saver when your Analytic App has more than a few questions (or tabs of questions) that need to be answered.
View full article
Did you know the average football game lasts 3 hours and 12 minutes and only amounts to roughly 11 minutes of play? Now, I love trying to eat Doritos through my TV screen as much as the next guy, but for me the highlights are definitely a better watch. The Summarize Tool would probably agree - the most effective communication of your data is the most concise summary of it. Whether it’s concatenating strings for storage, merging reports to have better readability, getting your spatial objects to interact, or even calculating averages and other formulas on groupings of data, the Summarize Tool can reframe your data to be more informative. This article provides a few examples on how.
View full article