In the first part of this series, I gave an overview of the Alteryx platform and some of the functionality offered by the SDK. The first parts of the SDK I am going to look at concern adding additional functions into the formula function library. There are two methods of doing this: XML Macro functions…
Alteryx has a huge built in set of tools (about 170 tools in v10.1 I think), but when something is missing or you just have a specific way you want to do something, it has various options on how you can extend it. The simplest way (and one of the most flexible ways) is to…
This posted started as a question on the Alteryx community about finding the nearest underground (subway if you prefer!) station to an address. I don’t have much experience working with addresses and map data, but thought their was probably a way leveraging the APIs Google maps provide. This feels very much like “standing on the…
Stealing this idea from Ken Black’s equivalent post on Tableau (sure he won’t mind!). As we have just had version 10.6 11.3 release think worth publishing a little guide on how to make Alteryx compatible with old versions! This comes up in the community a lot when answering questions and a user doesn’t have the…
There was an interesting question posted on the Alteryx community about which macro was best for calculating a weighted median. Adam Riley has a macro inside the CReW macros which does this, but wanted to see if it was possible to create one allowing dynamic selection of the grouping (like in a Multi Row Formula).…
Version 1.1 of my Alteryx formula add ins project has been released. These provide a set of utility functions for use wherever a formula can be used within Alteryx. The functions are developed in C++ and XML using the Alteryx SDK – I will write a few posts with the details of how to create…
Having created my simple framework for making custom C# based Alteryx tools, I thought I would release an initial version for people to take a look and try. Please note these are pretty experimental and while stable enough on my PC, I don’t have the resources of Alteryx to test widely and confirm stability. Please…
I am planning to do a blog series on extending Alteryx and various options that are provided to do this (but it takes me ages to write a post!). As part of learning some of the tricks for this I have been working on a set of Formula Addins (xml based)) and Custom DotNet Tools. I…
I was having a look at the public data the Met office provide on their website. They have a huge amount freely available on their website. I was interested in the historical data they provided for each of the stations accessible via this web page.The page allows you to download the data one station at…
I was doing some table calculations in Tableau and needed complete control over the rounding that was used. Tableau provides a single ROUND function. The exact specification of this (I believe) depends on the data source you are connected too, as it passes through to the underlying server. I needed to be able to look at…
James Dunkerley's Blog 