This post also appeared on the Alteryx Engine Works Blog. A friend on the Alteryx community recently asked me about recreating the Excel trendline capabilities within Alteryx. If you have the predictive tools installed then Alteryx has a Linear Regression tool which will fit a linear model to the set. This uses R and produces…
A group of my colleagues from Scott Logic and I went to the AWS Global Summit at the ExCel centre this week. It is the biggest of the global summits, and gives a taste of the huge re:Invent conference in Las Vegas. This post is my thoughts from my day and the sessions I attended.…
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…
So, I have far too many recipe cards… Over the years, I have collected (read hoarded) hundreds of recipe cards from trips to the supermarket. I’ve generally kept them in folders so I can find them when I want but I want to do better. I’d love to be able to search for them, find…
So I have now completed both the Solution Architect Associate and Developer Associate certifications and thought I would share my thoughts from the process. Why Bother? For a long time, I haven’t been particularly bothered by doing any certifications. I have always believed in proving myself in the work I do, and this was particularly…
This post is the start of a small series around some of the functionality coming in the Alteryx Abacus 1.4 release. While this post doesn’t directly use anything in the add-in, understanding the sequence of evaluation within an Alteryx expression is critical when working with variables (one of the big new features in the next…
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 –…
I’ve been using AWS Lambda for a little while now. It’s a great platform and allows you to rapidly get something up and running. So far, I’ve built them in both JavaScript and Python – both of which have been very straightforward. I’ve spent a fair chunk of my development life working in C# so…
For the last four years Eric Wastl has produced ‘the Advent of Code’. This year Adam Riley challenged us to try and do it in Alteryx: #AdventOfCode Days 1-3 look very solvable with @alteryx! Who is in to see how far we can get? https://t.co/Ogq1O6Ps6o — Adam Riley (@AlteryxAd) December 3, 2018 https://platform.twitter.com/widgets.js As December…
I have been meaning to upgrade my source code hosting and build process for a website I run from SVN to git in VSTS and finally got around to doing it. These are few of my tips I found in the process using Ubuntu on WIndows 10. Ubuntu (or other distributions) on Windows For the…
James Dunkerley's Blog 