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 ...
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, ...
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 ...
In this Design Pattern we are going to show you how to reshape data where there are repeating fields which have the same name. This is a common structure that you may encounter when new ...
In this podcast Chris and Joshua chat about whether you need a mathematical (saves the argument of whether it’s maths or math!) background to be a good problem solver in Alteryx. Drawing on recent experiences ...
This weekly challenge takes a look at creating unique combinations. This is a common requirement when you append many similar fields together. Chris provides a walkthrough of this weekly challenge, which not only is built ...
Every come across a dataset where there are a mixture of date formats used, such as dd-MM-yyyy, yyyy/MM/dd, MM-dd-yyyy? Using regex to solve for this by spotting patterns in the text could be the answer. ...
However you use Alteryx, it is likely that you will need to work with delimited text files. This is a core skill you will need to be able to parse the data into the relevant ...
