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.
Have you ever wanted to be notified if a workflow ran into an issue? Or get push notifications when incoming data quality didn't meet your standards? Check out the Twilio SMS Alert tool, which will send you a text message based on the tool's incoming data.
No one likes to see an error message, but as an Alteryx tool developer, you have the ability to make seeing an error a useful experience that helps guide the user through configuring your tool. This article will show you how to add error messages through the macro back-end or the front-end.
Want to leverage Alteryx capabilities in a web-app? Maybe you want to create your own data connector. Come as we introduce you to all of our developer tools so that you can show US what Alteryx is truly capable of.
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.
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.
This is an introductory explaination to the Detour tool, the handling of empty fields in Interface tools, and how these two concepts can work together. I show how this is used in a ranking macro I created. Then I provide an overview of rankings and how to use the macro.
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.
"How do I read from multiple Excel workbooks/worksheets?" is a question we hear fairly regularly. Let's put together an Alteryx macro that will read any number of Excel worksheets from any number of XLS, XLSX, XLSB, and XLSM workbooks.
"How do I read from multiple Excel workbooks/worksheets?" is a question we hear fairly regularly. Let's put together an Alteryx macro that will read any number of Excel worksheets from any number of XLS, XLSX, XLSB, and XLSM workbooks...just in time for the holidays
It has been a long time coming I know, but I hope you enjoy the new content. I'm pleased to say this pack has three new contributors from the community, something which I hope we can continue with future releases.
I had been with Alteryx for about two months when I started hearing people talk about CEF [Chromium Embedded Framework]. I did a little digging on my own, and true to its name, found that CEF was a framework for placing chromium based browsers within applications. Shortly after, I learned I would have a chance to use this technology myself for the upcoming release of Alteryx.
Developing resource-intensive workflows can be a challenge when testing changes involves running the workflow through iterations that may take several minutes or more before being able to see results. This post walks through using the Cache Dataset macro to develop workflows in a smarter way, avoid repeated long run times, and speed up the process of blending and analyzing larger sets of data.
Time series data is used in many of the industries we work with here at Alteryx. In some cases, we start with data that’s been measured by day and find that it’s a little too granular. The obvious solution here is to start rolling up the daily data into larger groups and experimenting with different aggregation levels, but this can quickly become difficult and/or tedious depending on the kind of aggregation you’re trying to do.
With that in mind, I decided to make a tool that would handle a lot of the work for you. The Date Aggregator allows you to take per-day time series data and roll it up into all sorts of different intervals.
People say you can spend upwards of 60% of your time “preparing” your data rather than analyzing it. Alteryx Designer has great, user-friendly tools to try to cut into that estimate, but the tools are purposefully generic so that they can be applied to as many situations as possible. If you find yourself applying the same sequence of tools over and over to get your data clean, perhaps a macro is in order.
If you’re one of those people who develops all your macros flawlessly the first time, congratulations: you don’t need the X-Ray Browse Macro. (And we’d love to get your resume.) This macro is designed for the rest of us: humans.
There was a recent question on the Alteryx forum: How to use the percentile in summarize.The question misunderstands the percentile function in the summarize and is looking for something slightly different, although with similar math. So what does the percentile in the Summarize tool do?