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).…
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…
Following on from another post on downloading Quandl into Tableau via Python and the Data Extract API, I wanted to try downloading the current components of the FTSE 100, and then for each one download the history of prices using Alteryx. Yahoo! finance has a web page with the members of the index: The list…
One of the most common data file formats I have to deal with is CSV files. Assuming your file is well formed (i.e. starts in the top row, with or without a header, in a nice continuous table), then there is no difficulty. Drag the file into Alteryx’s designer and it will create an Input…
While I had planned to write about CSV parsing next, I decided to cover a couple of other topics first. I plan to carry on and write about my experience parsing CSVs and then reuse via Macros and Formula Add Ons after that. Firstly an improvement to the last post, based on a comment from…
I have been spending a fair amount of my time at work using Alteryx Designer. It is a nice ETL tool and is a great tool for use along side Tableau. I have found myself using it as a proof of concept for a data flow before transitioning back to my traditional Visual Studio C#…
James Dunkerley's Blog 