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.

Quick navigation for the Tool Mastery Series!
View full article
Instruction on how to obtain the list of deprecated tools in Alteryx Designer!
View full article
The Find Replace Tool is one of those tools that goes relatively unused and uncelebrated until you stumble into a data blending technique that would be extremely difficult without it – at which point, it becomes your favorite tool in the Designer. You can find it in the Join Category and it’ll make easy string substitutions in your data that would otherwise require herculean effort to work around. Today, we celebrate Find Replace as a hero.
View full article
Question Does "Dictionary Sort Order" always place lower case letters before capital letters?  Answer Yes.  In the Sort-Configuration menu there is an option to "Use Dictionary Order".  When checked it will sort in alphabetical order with lower case first (e.g., a, A, b, B, c, C, etc.).   Input:   If you do not have "Use Dictionary Order" checked, it will sort all Upper case first and then all lower case (e.g., A, B, C, a, b, c, etc.).   Check "Use Dictionary Sort Order.     Dictionary Sort Order   Visit the sort help article or the attached workflow for more details.
View full article
How do I remove leading zeros from a field?  Use the Formula Tool  a nd the TrimLeft() function to remove leading zeros!
View full article
Looking to install additional R packages?  Here's how!
View full article
A large component of data blending is applying mathematical or transformational processes to subsets of your data.  Often, this requires isolating the data that complies with a certain criteria that you’ve set. The Conditional functions build expressions that allow you to apply processes to data that satisfy conditions you set.   #
View full article
You know that a huge part of conveying information to your audience is your visual presentation. Here's a way to increase the amount of information that can be shared with just a glance: Segment the data in a chart with color.
View full article
The Run Command tool is a great way to take your workflow to the next level of efficiency. It allows you to interact with the command line directly, just as you would if you were to access it manually and type in a command. Which is great because sometimes we have a lot of important things to do in the command line.
View full article
Tips and tricks on how to output multiple sheets to an Excel file with the Output tool or with Reporting tools. 
View full article
An R macro for parsing PDFs with images!
View full article
This is a quick guide to get you up and running with Alteryx!
View full article
"I have a bajillion files that I need to bring into my workflow... wayyyyyy too many for me to use individual Input Data tools! What's the best way to do this?"                            - every Alteryx user ever
View full article
Far more than just a window to your data, the Browse Tool  has a catalog of features to best view, investigate, and copy/save data at any checkpoint you place it.  That introspection to your data anywhere in your blending gives valuable feedback that often speeds workflow development and makes it easier to learn tools by readily visualizing their transforms. Be equipped, and browse through the catalog of useful applications below!
View full article
Scientific notation , or E notation , is used to more simply represent values that are very large or very small.  Rather than represent the vertical distance from the top of Mount Everest to the bottom of the Marianas Trench as 19795000 millimeters (why millimeters, you ask?  Well, why not?), expressing this distance in scientific notation, 1.9795e+7 mm, provides a more accessible way to understand the magnitude and precision of that value.  When databases and spreadsheets format data in scientific notation, that formatting may be carried over into Alteryx.  For some users, data in scientific notation can be problematic, especially if the data type is read in Alteryx as a string.  Some Alteryx users have posted their helpful ideas on dealing with converting data in scientific notation to the full numeric value, and the links to those discussion threads are provided below.  This article summarizes and demonstrates their ideas. 
View full article
So we’re now downloading all the network-shared documents we want thanks to instructions   posted on our Knowledge Base, and we’re on our way to mastering FTP in Alteryx. But what if we want to take it a step further? A lot of our users rely on FTP as a drop zone for datasets that are generated periodically (e.g. weekly, monthly, or quarterly datasets). We should then be able to schedule a workflow to coincide with those updates, automatically select the most recent dataset, crank out all the sweet data blending and analytics we have in our scheduled workflow, and proceed with the rest of our lives, right? Right. We can do just that, and with a little work up front, you can automate your FTP download and analysis to run while you’re enjoying the finer things in life. Here’s how in v10.1:
View full article
Every so often we get questions about a .tde (Tableau Data Extract) file that is being output from Alteryx that has a file size of 30k when the original data is much larger. When the file is opened in Tableau this error sometimes comes up: An error occurred while communicating with data Source ‘yourfilename.tde’
View full article
For any macro or analytic app – one of the inevitable questions that you may encounter is “how do I configure this to do what I need?” For example, if you build a macro that checks if two fields are equal, but sometimes you want to ignore the case such that “A” equals “a,” and sometimes you want an exact match. This is where the Interface Tool Category comes to the rescue, with a super-tool called Check Box!
View full article
Steps for Harvesting Data in Google Big Query!
View full article
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!
View full article