core.noscript.text
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.) Th...
Have you ever noticed that you can't do a left join or a right join in the traditional sense in a single step with Alteryx?
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 som...
We are very excited to be able to announce the launch of the Macro District in the Alteryx Analytics Gallery!
Is Fuzzy Matching a mystery to you? You're not alone. Do you wish it were easier? Of course--who doesn't like things to be easier? Let's learn why and how we use this powerful meth...
Batch macros can seem very intimidating, but they are really quite easy to build once you understand how they work.
Continuing the series prototyping HTML based visualizations, I want to look at spatial data. One of the strengths of Alteryx is that spatial data is just data. It doesn’t claim to...
I am working on a prototype for Alteryx of some new charting/visualization ideas. For most prototypes we do the audience would be strictly internal, but this time I am going to try...
I love maps. A picture is truly worth a thousand words. Creating a great map is writing a story. Sometimes that story tells the viewer what to think and sometimes it conveys inform...
This post originally appeared at: http://alteryxned.wordpress.com/2013/08/21/alteryx-reading-xlsx-directly/ Sometimes, it seems that Excel is the most popular database format for o...
For years we have been getting requests from our users for a web platform that will give more users in their organization access to the power of Alteryx.
Ah, the simple joys of the Sample tool. It has to be one of the easiest tools in Alteryx for new users to grasp. I know for myself, it is a frequently used method of selecting exac...
The 3rd problem of the Alteryx Grand Prix this year was to create an optimal set of sales territories for 5 existing sales offices. In order to judge the results, contestants were...
We got an issue report on our internal support email about the non-overlapping drive time (DT) macro being slow. In this case it was running 29,000 5 minute DTs against a nationwid...
The new Charting tool that will be in 6.0 contains a chart type called "Box and Whisker". For those of you who are not familiar with that type of chart, basically it is a statistic...
Since 1.0, people have been requesting looping in Alteryx. We have added a lot of features over the years to give various types of loops. The GenerateRows & MultiRowFormula tools g...
I never cease to be amazed at all of the things that Alteryx can be made to do. I was recently on a call with a client who asked if Alteryx could be used to dynamically serve up th...
Sometimes data comes in to Alteryx in an unexpected code page. One example recently is Tele Atlas started shipping their data in SHP files that are UTF-8 encoded.
I recently had a client ask if there was anything in the Alteryx API to help figure out what the questions were in a wizard.
What are Batch Macros?Batch macros are a new feature in Alteryx 5.0. They add some fairly simple capabilities that let you solve problems in ways that
Writing macros is like writing any other code. You have to get into a programmer mentality. Often you write a module completely differently when writi
Batch Macros are a major new feature that very few people will ever notice or use. We have gotten a lot of requests for looping features in Alteryx. P
We members of the data team crunch a LOT of numbers! Sometimes, our modules run agonizingly slow, so we decided it was time to review our best practic
The Sample tool is one of my favorites, but it is missing 1 crucial feature that is periodically asked for. That is the ability to return a random set
The other day, a feature request came in for making the formula tool into an input tool - i.e. not requiring that an input goes into the tool. I didn'
How do we build & test Alteryx? Thanks to Linda, we have a nice script that runs the Alteryx build every night, but building it is not enough. We
Have you ever pondered how we QA Alteryx? With over 70 processing tools that support hundreds of functions, just about any file type, field types, and