This is a slightly updated version of a blog post I first did in 2019, it is a fun use case to demonstrate APIs (more on that below) and how you can do something in ...
Why do you need to improve the batch input macro A typical first use case when teaching batch macros to Alteryx users is for the use case where the dynamic input tool produces a warning ...
In this episode we are joined by Paul Houghton, from the Information Lab, on the eve of his book release – Data Engineering with Alteryx. We hear from Paul how he got started with Alteryx, ...
It is December which means it is time for Advent of Code. This is an annual coding / programming challenge created by Eric Wastl, during December a daily set of small programming puzzles is set for ...
Excel! This isn’t a dig at Excel, as it is really useful, but when the priority of the spreadsheet is prettiness it can be a pain for a data analyst! One common problem is users ...
Ok, this one is not strictly a design pattern, but it’s a quick and simple way to easily rename fields of an input file, to what is expected by an analytic process downstream by using ...
Have you ever come across an instant where you need to have a field where the values within it can change based on a user input. Let’s take this input dataset: Source: mockeroo.com If in ...
If you are familiar with macros and apps, there are times where you want the behaviour of the app to change based on the user input. An example of this is a batch macro which ...
Are you a spreadsheet hero, but found that when you read the data into Alteryx the data doesn’t display as you would have expected? This is probably because you are using nested headers in your ...
I finally did it! After 4 attempts I passed my Expert Certification. When I posted the exciting news on LinkedIn, there were a few questions from fellow Alteryx users on tips for passing the exam. ...
