community
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.

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
Very large numbers don't behave the way users expect. Often, it's better practice to handle a big number like that as a String.
View full article
Set yourself up for success with excerpts from the 2017 Tips and Tricks Book for bringing data into your workflows!
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
Set yourself up for success with  excerpts from the 2017 Tips and Tricks Book for workflow design!
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
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
Thanks to the brilliance of  @RobertB  during last year’s Alteryx Innovation Days, we now have  a command line tool in beta  that generates visual markup in the Designer to compare two workflows!
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
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 TS Filler Tool t akes a data stream of time series data and fills in any gaps in the series.
View full article
Everything you need to get started with your own instance of Designer + Scheduler!
View full article
The consummate  Reporting Tool , the  Layout Tool  isn’t named after its ability to “layout” your reporting work like  Terry Tate, Office Linebacker . No, the name is borrowed from the tool’s core functionality to freely arrange reporting objects in your workflows to fit a templated, “layout,” format to be output by the  Render Tool . Giving you the flexibility to organize reporting snippets horizontally or vertically, set the width and height of columns and rows, and to add borders and separators, the Layout Tool is the last requisite step in compiling, formatting, and generating a report in Alteryx - probably to never be made by hand again!
View full article
For those who haven't used CONTROL+[SCROLL on your Mouse]. You can use this with filters & formulas (maybe more?). The result is the difference between night & DAY!
View full article
Why play fair when you can stack the deck in your favor?
View full article
The Field Info Tool  is another one of the gems hidden in the Developer Tool Category  – however don’t be intimidated, this is a tool for all of us! The purpose of the Field Info Tool is to give you the information about the fields in your data in a way that you can use down-stream as part of your workflow. There are no settings to configure, so just drop it on your canvas and you’re good to go!
View full article
With all the bells and whistles to play around with in the Reporting Tool Category , it’s hard not to leave some out of your reporting workflows every now and again. Just don’t forget about the Report Text Tool – the tool that’ll help you painlessly add text to your reporting objects, presentations, or documents to help spruce up their readability or formatting.
View full article
Believe it or not, data can be beautiful. Take your black and white data points and add some color to them in visuals with the suite of tools found in the Reporting Category https://help.alteryx.com/current/index.htm#Getting_Started/AllTools.htm#Report_Presentation_Tools ! If you’re looking to create reports, presentations, images, or simply output data with a bang, you can use the Render Tool https://help.alteryx.com/current/PortfolioComposerRender.htm paired with other Reporting Tools to create HTML files (*.html), Composer files (*.pcxml), PDF documents (*.pdf), RTF documents (*.rtf), Word documents (*.docx), Excel documents (*.xlsx), MHTML files (*.mht), Power Point presentations (*.pptx), PNG images (*.html), and even Zip files (*.zip) – packed with formatting and visual aesthetic that’ll make any data-geek’s mouth water.
View full article