Alteryx Designer Knowledge Base

Error: "An Item with the Same Key has already been added" with Sharepoint List Input Tool

This error occurs when importing a Gallery Data Connection, but there is an issue with the Gallery Data Connection.

"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

Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.

This article will walk through how to enable to Google Analytics APIs to be used in the Google Analytics Connector with OAuth2 login option

Errors and warnings occur when predictive model names contain spaces

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:\.....'

The error message appears when using System Settings in Alteryx Designer.

How to Resolve display issues in Designer

In some cases Designer is very slow when working from home. This can have several root causes.

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.

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.

Data preparation and investigation are a must for successful Predictive Modeling.

This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.

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.

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

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.

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.

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.

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.