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
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
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
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
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
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
A common task that analysts can run into (and a good practice when analyzing data) is to determine if the means of 2 sampled groups are significantly different. When this inquest arises, the  Test of Means  tool is right for you! To demonstrate how to configure this tool and how to interpret the results, a workflow has been attached. The attached workflow (v. 11.7 ) compares the amount of money that customers spent across different regions in the US. The  Dollars_Spent  field identifies the amount of money an individual spent and the  Region  field identifies the region that the individual resides in (NORTH, SOUTH, EAST, WEST).
View full article
The  Numeric Up Down Tool  can be used in a variety of ways to enhance your macros and apps. This very simple tool requires just a few seconds to configure and you're on your way!
View full article
The  Transpose  tool pivots data for all selected fields. The column headers are listed in the name field and the corresponding data items are listed in the value field. You can also select key fields which will remain unchanged through the transformation. The transpose tool is often used in conjunction with the  Cross Tab  tool, which essentially works in the opposite direction.
View full article
Have you ever wanted to restrict the fields that flow through your workflow based on their data type? What about only allowing fields that begin with the same word or are in a specific position? The  Dynamic Select  tool is just what you’re looking for!
View full article
A must-have for any app or macro, the  Error Message Tool  displays a prompt to the user based on input from  Interface Tools . Using any expression that evaluates to true, along with any number of user inputs from question  anchor connected Interface Tools, the Error Message Tool can layer even the most involved applications with failsafes that ease a user’s experience through more robust interactions.
View full article
The Arrange Tool allows you to manually transpose and rearrange your data. It can be used to combine multiple fields into a single target field.
View full article
The  ConsumerView Matching macro  enables users to match their customer file to the Experian ConsumerView data. Starting with customer information such as name and address you can leverage the ConsumerView macro in Alteryx to append a variety of information about your customers such as household segmentation, home purchase price, presence of children in a home, estimated education and income levels, length of residence, and many more!
View full article
The  Append Fields  tool adds  every  row of the source input to   every  row of the target input as new columns. This is also known as a Cartesian or cross join!
View full article
A part of the Spatial Tools Category, the Distance Tool calculates how far apart spatial objects are.
View full article
Binary Large OBject (BLOB) data types are often used to store images, audio, and other multimedia files/objects in a single, standardized, format for simplified database management - making them a frequent filetype in the Alteryx Designer. Fortunately, with the  Blob Convert Tool , along with the  Blob Input  and  Blob Output   Developer Tools , working with BLOB objects is no more difficult than the file types they represent!
View full article
The  Multi-Row Formula Tool  functions much like the normal  Formula Tool  but adds the ability to reference multiple rows of data within one  expression . Say, for example, someone was on the ground floor of a house and had a Formula Tool. They would only be able to talk to the people also on the ground floor. If they had a Multi-Row Formula Tool, though, they would also be able to talk to the people upstairs, in the attic, and in the basement as well.
View full article