This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
A customer recently asked how they could read in multiple files all at once from their HDFS server. The answer? Make a Macro! See how it's done and get a few nifty utilities to add to your bag of tricks.
Recently we celebrated the launch of our long anticipated Tool Mastery Series, a collective of Knowledge Base articles tasked with communicating the most inspired uses of each Alteryx tool. Check out how we automated all the hard parts and brought the series to life!
Do people regularly send you email attachments that are needed in your analytic workflows? If so, this blog post is for you. The Gmail Attachment Input tool automatically downloads email attachments into your Alteryx workflows. This is done through the use of the Google OAuth Macro and Google Gmail API.
Have you ever wanted to bring data from a Google service into an Alteryx workflow? You're in luck! Use the Google API: Retrieve Access Token macro to generate the Authentication token needed to make calls against Google APIs.
Generally, the release schedule at Alteryx consists of two major releases each year, and smaller releases as needed to fix critical issues or special requests. This week we will be launching a patch update to Alteryx that is a combination of critical fixes and minor updates.
The critical issue: Alteryx can sometimes become unresponsive when the computer it is running on goes in and out of sleep/hibernation or when the screen dimensions change dramatically like when attaching to dual monitors.
- In 10.1, we put in a fix to handle field renaming where we would recursivley rename field headers and wind up with unusable field names and it would take a really long time to complete. In applying this fix, we changed the behavior of renaming numerical field names. This was unintentional and we fixed this.
- We resolved a problem where inserting into a table that did not have columns in the table order failed.
This patch is now available from downloads.alteryx.com. We will be releasing one more update next week. The upcoming update will include support for Predictive Tools with R 3.2.3. If you work with predictive tools, you may want to wait until that update is released. We will activate the in product update notification next week with the Predictive Tools update.
What if the data has yet to be fully collected, much less structured, and you need to get to it without driving yourself crazy? More often than not, this is the case when it comes to trying to pull data off the internet and turn it into something a little more analytics-friendly, a process known as “web scraping”. It turns out that between the Download tool and all its great data manipulation tools, Alteryx actually makes for a really good web-scraping platform in addition to its wealth of other uses.