cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
 You are using an unsupported browser for translation. Please switch to another browser.

Quick navigation for the Tool Mastery Series!
View full article
Alteryx provides product technical support for a period of eighteen (18) months after the Release Date of each Release Version, as outlined in the tables below.   NOTE: You can find product 'Release Version' details for all Alteryx Analytics Platform products by following the steps here.   Alteryx Designer & Server Release Version Release Date End of Support (EOS) 2018.2.4.47804 5/31/2018 12/1/2019 2018.1.4.44311 4/2/2018 10/2/2019 2018.1.3.42973 3/6/2018 9/6/2019 11.8.3.40692 1/19/2018 7/19/2019 11.7.4.37815 11/28/2017 5/28/2019 11.5.1.31573 8/15/2017 2/15/2019 11.3.3.30523 7/14/2017 1/14/2019 11.3.2.29874 6/27/2017 12/27/2018 11.0.5.26351 3/21/2017 9/21/2018 11.0.3.25674 2/15/2017 8/15/2018 10.6.8.17850 7/12/2016 6/28/2018 10.6.6.17413 6/28/2016 12/28/2017 10.5.9.15014 5/5/2016 11/5/2017 10.1.7.12188 2/18/2016 8/18/2017 10.1.7.11834 2/4/2016 8/4/2017 10.1.6.11313 1/14/2016 7/14/2017 10.1.6.60263 11/30/2015 5/30/2017 Predictive Analytics 10/24/2015 4/24/2017 10.0.9.58949 9/26/2015 3/26/2017 10.0.9.58645 9/9/2015 3/9/2017 10.0.9.58529 9/3/2015 3/3/2017   Alteryx Connect Release Version Version Information Displayed in Product Release Date End of Support (EOS) 2018.2.4.47804 v18-2-6-20180418.134811-git.67cf65dd 5/31/2018 12/1/2019 3.0.0_0c4cae69 v17-4-7-20180212.164240-git.0c4cae69 3/6/2018 9/6/2019 2.0.0_05b4e5c2 N/A 11/28/2017 5/28/2019 1.0.1.31573 N/A 9/12/2017 3/12/2019 1.0.0.31573 N/A 8/15/2017 2/15/2019   Alteryx Promote Release Version Version Information Displayed in Product Release Date End of Support (EOS) 2018.2.4.47804 v2018.2.0 - Build 593b5b29 5/31/2018 12/1/2019 2018.1.3.42973 v2018.1.0 - Build 2bfb396 3/6/2018 9/6/2019   Alteryx Analytics Product Compatibility Policy Alteryx is committed to ensuring that workflows created in legacy versions of Alteryx Designer will continue to work as expected with newer versions of Alteryx Designer. Alteryx will identify any known workflow compatibility issues. With the release of 11.7, a user may convert workflows created in a newer version of Alteryx Designer for use in an older version of Alteryx Designer. In this 'downgrade' scenario, a dialog appears asking the user to confirm or cancel the conversion process. Conversions performed in this manner are not fully tested for compatibility. For Alteryx Designer users who also use Alteryx Server, Alteryx is also committed to ensuring that in an upgrade scenario, legacy versions of Alteryx Designer are able to successfully connect to and use the newest Alteryx Server version. Therefore, it is always recommended that Alteryx Server first and the Alteryx Designer installations are upgraded thereafter. Alteryx will identify any known upgrade compatibility issues. If you experience any issues with an upgrade, please visit alteryx.com/support.   Alteryx Designer Predictive Tools Compatibility Policy Alteryx Designer users can install predictive tools for use with open source R, or Microsoft R. This table details the versions compatible with each release of Alteryx Designer.   Alteryx Designer Version Standard R Version RRE - Revolution R Enterprise (renamed as Microsoft R Server in 2016) Microsoft R Client (MRC) Microsoft R Server (renamed as Microsoft Machine Learning Server in 2018) Microsoft Machine Learning Server (MMLS) 2018.2 3.4.4 Deprecated by vendor - Not supported 3.4.3 Deprecated by vendor - Not supported 9.3 2018.1 3.3.2 Deprecated by vendor - Not supported 3.3.2 9.0/ 9.1 NA 11.8 3.3.2 Deprecated by vendor - Not supported 3.3.2 9.0/ 9.1 NA 11.7 3.3.2 Deprecated by vendor - Not supported 3.3.2 9.0/ 9.1 NA 11.5 3.3.2 Deprecated by vendor - Not supported 3.3.2 9.0/ 9.1 NA 11.3 3.3.2 Deprecated by vendor - Not supported 3.3.2 9.0/ 9.1 NA 11.0 3.3.2 Deprecated by vendor - Not supported 3.3.2 9.0/ 9.1 NA 10.6 3.2.3 8.0 Not supported NA NA      
View full article
 When attempting to publish a workflow to your private Gallery which contains the Publish to Tableau Server macro, you may encounter an error similar to this:   “ Cannot find macro "PublishToTableauServer_v1.08.1\Publish to Tableau Server.yxmc"   This is typically due to one of two reasons:   The Publish to Tableau Server macro has not been installed on the Alteryx Server where the Gallery is located. The macro has been installed but has not been installed in the correct location, or the Gallery cannot access the macro for other reasons. Please see this link for instructions on correctly installing the Publish to Tableau Server macro on an Alteryx Server.   Even when the macro has been installed properly on the server, this issue can still occur, and if it does, here is a simple workaround to get your workflow published:   Save the workflow to the Gallery: From Designer, click on File > Save As and choose your Gallery. Add the Tableau macro components as assets of your workflow: Click on Workflow Options > Manage workflow assets. Select all of Publish to Tableau Server related assets (currently there are four). Including these assets when publishing should allow the workflow to publish and run successfully in the Gallery.   Thank you!
View full article
 This error is usually caused by two things: The file you selected is of a different format than what is selected in the File Format drop down in the Configuration window. A .yxdb file you are using as an input has become corrupt. Other causes can be found here: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Error-FileID-does-not-match-in-the-FileHeader/ta-p/19870   Although extremely rare, if a .yxdb file becoming corrupt is the culprit (one cause is a network connection dropping in the middle of writing the file), you may have a quick and simple way to resolve this potentially stomach-dropping issue:   Open up Windows Explorer and navigate to the file. Right-click on the file and choose Properties. Click on the Previous Versions tab. If you're lucky, there is at least one option of the file that you can revert back to you, hopefully allowing you to avert disaster. Obviously, this doesn't just work with Alteryx files, so perhaps this knowledge will come in handy with other files.   Thanks for reading!
View full article
The 'How to Guide' to Cognitive Services Text Analytics Macro    As Microsoft continues to grow it's Machine Learning capabilities, Alteryx is following suit and has built a new connector taking advantage of Microsoft's Cognitive Text Analytics API.   The new Cognitive Services Text Analytics Macro will replace the AzureML Text Analytics Macro, keeping sentiment analysis and key phrase extraction, while also adding Language and Topic detection.   To use this macro you will need to create a Microsoft Account, as well as signing up to the  Microsoft Azure Account.   Sign in or create a Microsoft Azure Account and this should take you to the Azure portal. You will need to click on 'Create a resource' and search for 'Text Analytics'.      You can then click 'create' in the bottom right corner.        You will need to set up a subscriptions if you haven't already. Once you set up an account, you can return to this stage and continue.   Once you have set up a subscription you will be able to create an application by filling out the following window. Hot 'Create once you are finished and this prompt azure to deploy this application (This may take a minute - you should see it in the top right of the web browser).     You can then click on the notification tab and Pin to Dashboard then go to resource.     Once you have done this you should see the screen below: (If you don't please refresh or sign in & out of cognitive services until you see the information you added above within the information ribbon below).    Click on keys, then copy and Paste them into the Cognitive Services Macro and select your field and type of text analysis.   Common Errors:   Error: Invalid subscription key   This error tends to occur because the account hasn't fully been processed by Microsoft.   Solution: Please log in & out of Azure, verify the information looks correct and then copy and paste the key into Alteryx.      Best,   Jordan Barker Solutions Consultant
View full article
You may have run across this error, using the html plugin predictive tools (Linear Regression, Logistic Regression, Decision Tree):   Logistic Regression: Error in searchDir(dbDir, lang) : Logistic Regression: Expecting a single string value: [type=NULL; extent=0]     In 2018.2, this can happen when you have previously had an Admin version of Designer installed, but have since uninstalled.  Once you've installed the 2018.2 non-Admin version with Predictive tools, these errors will now occur.   Help is on the way!  (In the form of suggestions and an upcoming stable release.)  You have several options.  First, you can install an Admin version of Designer concurrently - 11.8, 2018.1, 2018.2, etc.   Last ditch effort: delete registry keys.  This is not recommended - only delete keys if you cannot install a current version, or cannot wait until the next stable update.   Step 0) Save your license key somewhere easy to find: Options> Manage Licenses   Step 1) Open the Registry Editor (type regedit into your windows search bar) and delete the following directory: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx   Now, go predict stuff!  Happy Alteryx-ing.
View full article
You know what really stinks? Working with addresses that aren’t standardized or verified. Whether human-input, or one of the many address formatting standards in the U.S., being stuck with an address you can’t either (1) identify or (2) ensure it exists can be a real pain in the… well…   CASS is here to help!
View full article
  Our incredible user community came through once more with their most valuable Alteryx tips & tricks, these along with our own are now captured in our Tips & Tricks 2018 book.   Our sincere gratitude to our user community for their contributions and for attending our session at Inspire 2018 !   Enclosed is our 100 + pages of tips & tricks … enjoy !     Margarita, Henriette & Jessica Customer Support Engineering
View full article
How do I use that tool? When it comes to tools, Alteryx has a full box! With over 200 tools and macros in the basic installation, you may wonder how you'll master them all. Don't worry - we have 'apps' for that!   Alteryx tools are designed to be focused and specific in their function - simple, yet powerful. Understanding what goes in and out while grasping what happens in-between makes the most sense in a workflow and that is why we have One-Tool Examples in the product.    One Tool Examples   One Tool Examples are sample workflows that demonstrate different configuration options for one tool at a time. You can access them a couple of different ways:   1 - From the Help Menu: Go to  Sample Workflows > Learn one tool at a time > Tool Category     2 - From the Tool Palette: Click on a tool and then click Open Example:   3 - From Global Search: Search a tool name. If that tool has a One Tool Example, an Example button will display on the right. Clicking the Example button will open the One Tool Example:     The following list of tools, organized by tool category, have a One Tool Example in Alteryx version 2018.2:   In/Out Preparation Join Parse Transform Reporting Spatial Interface Data Investigation Developer Documentation Browse Directory Input Data Map Input Output Data Text Input                          Auto Field Data Cleansing Filter Formula Generate Rows Imputation Multi-Field Binning Multi-Field Formula Multi-Row Formula Random % Sample Record ID Sample Select Select Records Sort Tile Unique Append Find Replace Fuzzy Match Join Join Multiple Make Group Union                       DateTime RegEx Text To Columns XML Parse                             Count Records Cross Tab Running Total Summarize Transpose                           Image Map Legend Splitter Builder Render Report Footer Report Header Report Map Report Text Table                     Distance                                     Action Condition Check Box Date Drop Down Error Message File Browse List Box Map Numeric Up Down Radio Button Text Box Tree           Field Summary Pearson Correlation Spearman Correlation                               Base64 Encoder Block Until Done Dynamic Input Dynamic Rename Dynamic Replace Dynamic Select Field Info Message Test                 Comment Explorer Box Tool Container                                      
View full article
A close relative of the  Layout Tool , the  Visual Layout Tool  is the newest, and coolest,  Reporting Tool  on the block. Sporting all the badassery of the original Layout Tool in its ability to format and arrange reporting objects, the Visual Layout Tool differentiates in that it provides an intuitive, visual, interface that allows for easy drag-and-drop organization of multiple reporting object inputs. Basically, it’s the reporting tool category equivalent of upgrading from Paint to Photoshop.
View full article
Don’t know the area of your polygon? Need the length of your line? Do you want your spatial object’s X and Y coordinates? Don’t Panic! The Spatial Info tool can translate all that information and more!
View full article
The  Radio Button Tool  can be used in a number of ways. This is a simple tool to configure but can be very powerful!
View full article
The  Date Filter  tool is a very tailored version of the  Filter  tool with an enhanced  GUI  for date picking.
View full article
Looking for more premium connector and tool content to better equip your Alteryx platform for success? Check out what our partners have been up to!
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
If you are building a predictive model, inevitably you will want to analyze the effect that your independent variables have on your dependent variable. This article is meant to shed some light on the Alteryx-specific options for this type of analysis!
View full article
Following the launch of our premier  Developers Space Community  for all things surrounding Alteryx platform extensibility we are happy to share our b rand new design for our Developers Help Page!
View full article
The  Dynamic Replace Tool   is an under-utilized tool in the   Developer Toolset  that is very powerful. It allows for dynamic formulas or conditions to be used in your workflow.  It was first introduced in Alteryx 6.1 . It’s one of the few tools that is currently multi-threaded which makes is fast.
View full article
 Unfortunately at this time, non-U.S. and Canadian geocoding is performed via API calls, and as such, requires an Internet connection.
View full article
The humble  histogram  is something many people are first exposed to in grade school. Histograms are a type of bar graph that display the distribution of  continuous  numerical data. Histograms are sometimes confused with bar charts, which are plots of categorical variables.
View full article