cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
Announcement | We’re thrilled to announce our newest Alteryx Designer Expert Certified users! Learn more.
 You are using an unsupported browser for translation. Please switch to another browser.

Quick navigation for the Tool Mastery Series!
View full article
First added to Alteryx Designer in version 10.6, the Optimization Tool is a member of the Prescriptive Tools (included with the Predictive Tools installation) and allows you to solve optimization problems. Mathematical Optimization is the selection of the best possible option(s), given a set of alternatives and a selection criterion. In this Tool Mastery, we will review the inputs, configuration, and outputs of the Optimization Tool.
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
The Alteryx Forest Tool implements a random forest model using functions in the randomForest R package. Random forest models are an ensemble learning method that leverages the individual predictive power of decision trees into a more robust model by creating a large number of decision trees (i.e., a "forest") and combining all of the individual estimates of the trees into a single model estimate.  In this Tool Mastery, we will be reviewing the configuration of the Forest Model Tool, as well as its outputs. 
View full article
Typically the first step of Cluster Analysis in Alteryx Designer, the K-Centroids Diagnostics Tool assists you to in determining an appropriate number of clusters to specify for a clustering solution in the K-Centroids Cluster Analysis Tool, given your data and specified clustering algorithm. Cluster analysis is an unsupervised learning algorithm, which means that there are no provided labels or targets for the algorithm to base its solution on. In some cases, you may know how many groups your data ought to be split into, but when this is not the case, you can use this tool to guide the number of target clusters your data most naturally divides into.
View full article
Clustering analysis has a wide variety of use cases, including harnessing spatial data for grouping stores by location, performing customer segmentation or even insurance fraud detection. Clustering analysis groups individual observations in a way that each group (cluster) contains data that are more similar to one another than the data in other groups. Included with the Predictive Tools installation, the  K-Centroids Cluster Analysis Tool  allows you to perform cluster analysis on a data set with the option of using three different algorithms;  K-Means ,  K-Medians , and   Neural Gas . In this Tool Mastery, we will go through the configuration and outputs of the tool.
View full article
The Publish to Power BI Tool has been deprecated and replaced with the Power BI Output Tool. See here for more information about the Power BI Output Tool: https://help.alteryx.com/current/MicrosoftPowerBIOutput.htm The rest of this article refers to the deprecated Publish to Power BI Tool. By combining Alteryx and Microsoft Power BI, organizations can streamline and accelerate the process of preparing and analyzing data. This provides a faster way to deliver an end-to-end experience for data access, preparation, analysis, visualization and consumption — delivering deeper business insight faster with a more complete set of data.   With the new macro connecting to Power BI within Alteryx is even easier!   Depending upon your intentions with the Power BI tool you may need to sign up for Power BI and Microsoft Azure or just Power BI.  If you are only using Power BI independently then Option 1 will be fine, however if you have corporate deployment of Microsoft Azure then Option 2 would be best.   Option 1: This option is ideal if you would like to manipulate your data in Alteryx and then use the visualization methods inside Power BI. This set up is perfect if you are not looking to manage users or connect to local or network directories.   Create a Power BI Account using the 'Get Started Free' Link Follow the steps below Option 2: This option if for a cooperate deployment who utilize the Microsoft Azure. To use the Alteryx application it needs to be registered by your Azure administrator and a Client ID obtained from them. When using an account you setup yourself, you'll need to perform the following Azure Active Directory administration tasks to obtain the Client ID. It is recommended to get help from someone familiar with Azure Active Directory management, however the links below give good step by steps guides on how to set this up.   Create a Power BI Account using the 'Get Started Free' Link Create an Azure Active Directory Tenant Register a Client App Obtain a Client ID If you are unsure if you would need integration between Power BI and Azure here is a useful video explaining the integration.  Follow the steps below Once you have selected your option let's move over to the Designer!   Step 1: Let's move to Alteryx   The Power BI tool can be found in the connectors category once installed from the Macro District on the Alteryx Gallery or the The Alteryx Starter Kit for Microsoft     You can now drag the macro onto the canvas and use it to upload your modified data to Power BI. Step 2: Configuration – Dataset Name   Enter the dataset name as you want it to appear in Power BI   Step 3: Configuration – Table Name   Enter that table name as you want it appear in Power BI   Step 4: Operation   Create New: This will create a new dataset/table. If the dataset already appears it will append ‘_2” to the dataset name. Append: This will append records to the existing table. (Dataset name has to be exact) Replace: This will overwrite the existing table. (Dataset name has to be exact)   Step 5: Advanced Tab   Interactive authorization: This option will prompt the user for their username and password for Power BI. If you are looking to schedule this workflow or upload to the Gallery please choose ‘Hard-coded credentials’ because the interactive authentication will not be able to retrieve the client ID. Refresh token: This option caches a ‘refresh token’ which allows the user to re-run the workflow without the needs to re-authenticate until the refresh token expires. (Check with Microsoft for expiration policies). Uncheck this box if attempting to publish to a different Power BI account so that the user will be prompted for a different username. Unchecking this box and running the workflow will delete the cached refresh token which could be useful if the token becomes corrupted. Hard-coded credentials: Please enter your Power BI Username; Password; and client ID. To obtain. This is the ideal choice if you are looking to schedule or run this workflow on the gallery.   Step 6: Run the workflow!   You can now run the workflow and Publish to Power BI.   Tips and Tricks   Our best practice is to select ‘Work or school account’ Power BI has about a 2GB limit in the cloud, so clean it up now and then.   Common Errors   Publish to Power BI (2) Tool #2: The external program "PBIGetAccessToken.exe" returned an error code: -532462766.     This error is related to write permissions when writing out the access token. This error should be fixed in the latest release on the Macro District As the Tips and Tricks mentioned please select ‘Work or school account’ and enter your credentials. This will prompt a new permissions window. Please hit ‘Accept’ and you should be able to write out the access token correctly.   If you continue to get this error please run Alteryx as Administrator.     Error: Publish to Power BI (48): Tool #4: The type initializer for 'Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext' threw an exception.   Please check your .NET Framework (the easiest way to find out is probably to navigate to your installed programs via control panel), this tool requires a .NET 4.5 framework.     [Publish to Power BI (1) Tool #4: Loading an assembly required for interactive user authentication failed. Make sure assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms, Version=2.12.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' exists]   This issue occurs when one of the dependent files (Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms.dll) is missing or corrupt. Re-installing the tool should resolve this issue.     Power BI API error….HTTP/1.1 400 (‘error”(code…….     Open PBIX from Power BI webapp, then try to use macro to append/replace dataset of same name as PBIX results in error. The solution is to use a different dataset name. This is a bug in our JSON Build tool please do not have fields containing a period     The browser based authentication dialog failed to complete. Reason: The download has failed (the connection was interrupted)     Please enable TLS in IE advanced settings within internet options.       Authentication failed: Refresh Token is malformed or invalid     The refresh token is corrupted, please delete the refresh token in the same folder of the macro or uncheck refresh token in macro interface.       An Array can’t be at the top level     This is a bug with our JSON build tool please do not start with a number   If you continue to have problems with the Power BI Macro please contact Alteryx Support.   Best,   Jordan Barker Professional Services  
View full article
Tired of connecting tools one-by-one? This can definitely become inconvenient when you want to join/union many inputs or if you want to run a slew of analyses...
View full article
The Neural Network Tool in Alteryx implements functions from the nnet package in R to generate a type of neural networks called multilayer perceptrons. By definition, neural network models generated by this tool are feed-forward (meaning data only flows in one direction through the network) and include a single Hidden Layer. In this Tool Mastery, we will review the configuration of the tool, as well as what is included in the Object and Report outputs.
View full article
Sometimes you look at the steaming pile of data before you and wonder how you’ll ever get it in the form you need. Every option seems to require a great deal of manual labor, and as a lazy– er that is , as a data blending professional , that is simply something you will not abide.
View full article
If you are developing with Alteryx's In-Database tools you may want to share the workflows with users who do not have as much database experience.  Below is an example workflow to create a macro that will allow your users to select which fields are brought out of the in database tools without interacting with the in database tools directly.    The premise of the process is that you can stream out a single record of your table, then leverage a List Box tool in select mode to de-select the fields your user does not want to pull. From there, you can use Field Summary and Summarize to create a select statement that will be used to update a Dynamic Input In-DB tool.    To run in your environment, update the Connect In-DB tool to a connection that exists on your machine and start with a select all query.
View full article
To assist you in your R adventures in Alteryx, we've developed a R Tool Cheat Sheet which you can download to have as your very own. This article reviews and explains the functions included in the Alteryx - R cheat sheet. 
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
Imagine this – you’re on vacation. You’re on a sandy beach where the sun has been relentless all day. It’s hot and you need something to cool you off. Ice cream would be perfect!  The  Find Nearest  tool can help!
View full article
The Sample Tool allows you selectively pass patterns, block excerpts, or samples of your records (or groups of records) in your dataset: the first N, last N, skipping the first N, 1 of every N, random 1 in N chance for each record to pass, and first N%. Using these options can come in the clutch pretty often in data preparation – that’s why you’ll find it in our Favorites Category, and for good reason. While a great tool to sample your data sets, you can also use it for:
View full article
As most of us can agree, predictive models can be extremely useful. Predictive models can help companies allocate their limited marketing budget on the most profitable group of   customers,  help non-profit organizations to find the most willing donors to donate to their cause, or even determine the probability a student will be admitted into a given school. A well-designed predictive model can help us make smart and cost-effective business decisions.
View full article
You’re creating an app that involves dates. You want the user to be able to dynamically select the dates being used in the app, though. The tools you already know may not work. A  Text Box  would be too messy and allow lots of room for error. Pre-defined  Drop Downs  and  List Boxes  aren’t dynamic enough. Ah ha! What about that tool that looks like a calendar? The  Date  tool in the  Interface  category provides the perfect solution!
View full article
A part of the Spatial Tools Category, the Distance Tool calculates how far apart spatial objects are.
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
A product idea recently introduced the ability to compare workflows using the command line from Windows. I thought it would be good to turn this idea into a more GUI friendly Alteryx Analytic App!
View full article