So it’s that time of the year again – it’s even snowing here in London as I write this. That means it’s time for the Advent of Code. For those who haven’t heard of it, this is a fantastic set of 25 puzzles released one by one every day in December until Christmas Day. Each…
In this post, I will use the results from my last post to review how each category has performed against the sales targets the company has set. The completed workflow from that post can be downloaded from GitHub. The sales targets are stored in a JSON file, so they must first be parsed and then…
In this post, I will build on top of my last post and go over how to parse values in the dataset, select down to just the columns we are interested in, and finally aggregate the data. The previous post covered installing Enso and then loading in some data. This post starts from the workflow…
In this post, I will use Enso to read and process a CSV file. Enso is being designed and built to make it easier to process, blend and analyse data. It is a new programming language designed to have a dual representation both as text and as a visual graph. The dataset used in this…
Enso is a functional programming language that lets you quickly and simply load, blend, and analyze your data. We’ve been building out the core capabilities of the product and are rapidly working on the IDE and cloud release to give a straightforward experience for users using it. To show some of the new capabilities, I…
Some members of the team building Enso decided to try and tackle last year’s Advent of Code using the language and see how far we could get. I’ve previously tried solving Advent of Code in Alteryx and was personally interested to know whether it is easier or more challenging with what we are building. For…
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…
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…
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…
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…
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.
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…
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…
So the lights are up across London, the weather is atrocious and the trains are going nowhere fast; so it must be time to think about the Advent of Code. For those of you who haven’t heard of it, this is a fantastic set of 25 puzzles released one by one every day in December…
So mostly for entertainment sake and to see how easy it would be, I wondered if I could create a Python-based lambda in AWS using GitHub and Visual Studio Online. So, let’s see how this goes and how long it takes … Pre-Requisites For this little experiment, you will need: A GitHub account An Azure…
James Dunkerley's Blog 