ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
There are three model options in the Logistic Regression Tool; logit, probit, and cloglog. This post discusses which one is the right one for you.
View full article
In this post, a user asked if you can merge cells in the Table Tool like you can in excel. There are lots of ways you can get creative with the Table Tool, for example you can have your report span across the page in multiple columns as described here or you can add totals to your data to add to your report or create headers and sub-headers as described here.    So, how do you merge cells using the Table Tool itself? You can merge cells by nesting a table inside another table:   Tables can be nested more than one deep, you could start off with city, roll up to region, and then to state:    To clean up the doubled up header rows that are created when nesting tables like that, deselect "show column headings" in the Table Tools' settings:       .... and create the header row in a separate Table Tool. In this example, we are also changing the background color and making the font bigger, and changing the wording to "Region" for the Region column:      Lastly, there should also be subtotals for each region.   As with anything in Alteryx, there are different ways of doing this, they could be added as described in   this post, or the process used to create the headers can be used. First, the data is summed to create totals, then the totals are put into tables grouped by region:       Lastly, the table snippets are combined in a Layout Tool using the "Vertical Merge Contents to Line Up Table Columns" option:      Also see the attached v2018.1 workflow for the complete example. 
View full article
Ever needed to learn how to use an Iterative macro? This article walks you through the process with a basic mathematical problem highlighting how the data moves through the macro and loops back to continue processing.
View full article
Use the following instructions to download and complete installation via the Alteryx installation wizard in v11.0!
View full article
Reading XML in Alteryx is a little different than other input types and the reason for this is simple - XML is not a tabular data format and the data structure can vary from one file to the next. To effectively read and parse XML data in Alteryx, you need to use a combination of tools, namely the Input tool and the XML Parse tools .
View full article
Tired of pulling conversion rates manually? Me too!   Let’s build ourselves a currency converter in Alteryx Designer version 10.1 using the http://fixer.io/ exchange rates. Fixer.io is a free JSON API for current foreign exchange rates published by the European Central Bank. The rates are updated daily around 3PM CET.   The first thing we will do is gather the API documentation from the Fixer.io website. This will give us the URL we need to make our REST API call. If you are unfamiliar with making REST calls please take a look at Tasha’s
View full article
Need to download a file from file transfer protocol (FTP) in a Designer workflow?
View full article
The  Field Summary Tool  analyzes data and creates a summary report containing descriptive statistics of data in selected columns. It’s a great tool to use when you want to make sure your data is structured correctly before using any further analysis, most notably with the suite of models that can be generated with the Predictive Tools.
View full article