This is post is taken from the WIki for Alteryx Omnibus library. The technical details of how plug-ins work within Alteryx will be covered in later posts of the Beyond Alteryx Macros series. This is a walk-through of creating a custom tool for Alteryx using the Omnibus framework. The tool we are going to create…
Updated to version 0.5.3 to correct major bug in the XML Input tool After a fair degree of restructuring and rewriting, version 0.5.2 0.5.3 of OmniBus tool has been released to GitHub. Alteryx Omnibus Unit Tests Release Page This version represents a separation of the framework and the add-ins hopefully making it easier for others to…
Alteryx has released version 11 of both the designer and the server. It has a lot of nice improvements and few changes worth being aware of. I don’t use the server so this post is just going to concentrate on the designer and the features I have noticed. The move towards HTML5 based property panels…
Updated the links to versions 1.2.1 as a file was missing from 1.2 The latest release (version 1.2) of my Alteryx formula add-ins project (now called Alteryx Abacus with thanks to Chris Love) is now available. These are a set of utility functions for use wherever a formula can be used within Alteryx. The functions…
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…
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#…
