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.

We are proud to introduce you to the Manage Data Connection functionality in 11.0!
View full article
Connecting to Hadoop HDFS/Hive/Impala/Spark with Alteryx 11.0.
View full article
Connecting to Google Analytics is becoming more and more popular. There are a few things you need in order to use the Google Analytics macro; a Google Account (e.g., Gmail) and authorized access to an existing Google Analytics account. This article will help you get the rest of the way.
View full article
The Oracle connection has been redesigned for Alteryx 11.0 and it is now much easier to connect
View full article
Is there a workaround for not being able to use the Folder Browse Tool in the Gallery? Though it may not be as clean as being able to use the Folder Browse Tool, the simple workaround for this is to use the Text Box Interface Tool instead. This will allow the user to copy a directory path from Windows Explorer and paste it into the Text Box. In the workflow, all you need to do is connect the Text Box Tool to an Output Data Tool and have the Action Tool update the path portion of the Output Data Tool. You can even enter in a default path in the Default Text section of the Text Box if there is a path that is most commonly used.
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
A few months ago, I found the free space on my hard drive shrinking significantly on a daily basis, but for the life of me I couldn't figure out the cause. As it turned out, I was suffering from a Windows issue that I was not alone in dealing with. I was able to get the issue resolved by our IT department, but not before I spent a fair amount of time searching through my directories, compressing and deleting files, running Disk Cleanup, etc., none of which was particularly helpful. So, I decided to look to Alteryx for an answer.   I created a simple workflow (attached and created in 11.0) which uses the Directory tool to read the attributes of all of the files on my computer. Then, I grouped the files by directory and summarized the file size. After a sort, I instantly found the culprit. There were hundreds of CAB files (a Windows archive file format) that were 100 MBs each which were being created erroneously by Windows. I was able to share this with my IT associate which helped him greatly in diagnosing and subsequently fixing the issue.   Most of you are unlikely to be experiencing the same issue (but if you are, you're welcome  ). However, this workflow may come in handy for other reasons. If anything, just to help you manage your files and disk space by pointing out which files are hogging up all of your hard drive space!   Thanks for reading!
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
Brand new design!  Same helpful information.  Find the familiar table of contents and search bar by clicking the menu (inside the green rectangle). Getting Started resources include connecting to data sources, building workflows, and learning tools.
View full article
Use the following instructions to download and complete installation via the Alteryx installation wizard in v11.0!
View full article
One trick I often use to conditionally update a field is the Boolean  IIF  function.  IIF is basically a shorthand version of a single condition test.
View full article
You probably already know that you can output results to multiple sheets of an Excel file.  If not, you should check out  our resource  that explains how to do that very thing.  But what if you run that workflow every day, and you want to keep the outputs from days past?
View full article
The standard search within the Designer has been replaced with Global Search . Global Search now allows users to search from the Tool Palette, the Alteryx Help Documentation, and the Alteryx Community in one search bar.
View full article
As we learned about this hidden gem through the Tool Mastery | Tool Container article, exciting changes happened to this tool for Alteryx 11.0.
View full article
We continue to improve the user connection experience and hope the enhanced Input Data Tool will allow users to connect and manage their data much more easily.
View full article
Now connecting to SharePoint 2016 and SharePoint Online! Everything else is the same.
View full article
As of the release of version 11.0, the Alteryx Designer supports reading in single and multiple input files in a zipped archive file (.zip) .  Now, multiple files of the same file type in a zipped archive can be read into the Designer in a standard Input Data Tool .
View full article
Welcome to the 11.0 Formula Tool!  While no functionality has been removed from the tool's capability, significant UI changes have been made to this favorite tool in version 11.0.  This article outlines some of these changes to help you get ramped up and ready to go!
View full article
You can type directly into the Comment Tool in 11.0! Just double click!
View full article
With the release of 11.0, we see numerous changes to many tools in the Designer. The Linear Regression Tool gets a UI makeover and some cool new features are added that we will explore in this article. If you are new to performing regression analysis in Alteryx, I highly recommend checking out the Tool Mastery article which goes into everything there is to the old tool. Everything presented in that article remains valid as no features were removed. In this article, we will delve into the changes and new features.
View full article