# Alteryxing The Advent of Code 2020 – Week 4

It’s the end of the Advent of Code for 2020. The last week was tough – the part 1s were fairly easily doable, but part 2s often were a lot harder. In the end, I managed to solve all of this week but 1 in BaseA Alteryx. For the one I couldn’t, I used BaseA…

# Alteryxing the Advent of Code 2020 – Week 3

So week 1 and week 2 were both possible in BaseA Alteryx, although getting harder as the puzzles progress. Week 3 was the first time I needed to go beyond BaseA to find a solution for a couple of the parts (though in at least one case the community found a BaseA solution). As with…

# Alteryxing the Advent of Code 2020 – Week 2

So week 1 was well suited to Alteryx, let’s see how week 2 unfolded! A nice and gentle Sunday puzzle lulled me into the belief that it was going to be an easy week, followed by the first needed use of an iterative macro, and then something that looked far too much like the dreaded…

# Alteryxing The Advent of Code 2020 – Week 1

So it’s December and time again for the annual Advent of Code. For those not familiar, this is a set of 25 puzzles (each with 2 parts) set by Eric Wastl. They have a Christmas theme and story and are solvable with just a little programming knowledge and some puzzle-solving skills. The puzzles start quite…

# Creating a Mandelbrot Set in Alteryx

In this blog, I look at a few different ways to recreate the Mandelbrot set within Alteryx using just the BaseA tools. Along the way taking a look at pros and cons of each approach and the performance of the new AMP engine.

# Cubic Spline in Python and Alteryx (BaseA!)

As a bit of a thought experiment, I wondered if how hard it would be to create a cubic spline interpolation within Alteryx. As with many of my games BaseA rules apply. Stealing an idea from Tasha Alfano, I thought I would do it in both python and Alteryx from first principles. A quick shout…

# Solving Matt Parker’s Coin Puzzle in Alteryx

Matt Parker is publishing a weekly puzzle on his Think Maths website every Wednesday. This week’s puzzle was a Coin Puzzle. This puzzle felt like one that Alteryx would be well suited to solving. Representing the Board’s State The board looks like: Each location can either have a coin or not have a coin. This…

# An Overview of the Alteryx Abacus Add In

This post first appeared on the Alteryx Community The Abacus add in is a collection of custom functions that make writing expressions in Alteryx easier or gives completely new functionality (such as variables). Originally created to make my life easier, they have grown into a powerful extension for Alteryx that can speed up the creation…

# Creating an Alteryx Custom Function in C++

At Inspire EU 18, I presented a talk on how to create custom functions for Alteryx. As I described, there are two options available – XML Macro functions and C++ Coded functions. In a previous post, I have gone through creating an XML function. This post will look at creating a very simple function –…

# Beyond Alteryx Macros – Creating an Analytic App Installer for the Abacus AddIn

This started out as a fun experiment to see if it was possible to replace the current PowerShell based installer for the Alteryx Abacus function library with an Analytic App, but I like the result so think this will be the new installer for it! Along the way used some GitHub REST APIs and a…