Engine Works

Under the hood of Alteryx: tips, tricks and how-tos.
TaraM
Alteryx Alumni (Retired)

It is official... Alteryx 5.0 was released on Friday November 20, 2009. It is on its way to our devoted users and loaded with new features and functionality.

 

I will be conducting the What's New in 5.0 webinar tomorrow, Tuesday December 1 at 2pm Mountain Time. If you haven't done so already please register as I will be touching all the new stuff and directing you to where these gems are located in the program. This session will be recorded so you can play back at your leisure. To register click here.

 

The Customer Advantage group has already scheduled instructional webinars on the new features of Alteryx 5.0. You can register for them here.

 

We've been blogging about some of the latest features since the summer. Below is a list of the highlights of this release and hyperlinks will take you to the posts on those topics:

 

  • Dynamic Select and Dynamic Rename Tools – these new tools enable developers to create more adaptable wizards and work with a wider variety of data.
  • Report Formatting Tools – two new tools in the reporting category – Arrange and Overlay – provide greater flexibility in creating customized reports. The Arrange Tool enables transformation and rearrangement of data fields for more meaningful presentation of information. The Overlay Tool allows report content elements (e.g. maps, tables, images, etc.) to be overlaid on top of each other.
  • Reporting Email Tool – this tool creates automated email attachments of Alteryx module outputs, which then get directly sent to the defined recipients.
  • Batch Macro - enables automated program looping within a single module. Allows for target analysis of individual records/groups that need to be isolated from each other.
  • New Macros – six new macro tools have been added, including several different statistic calculations and a macro that returns a count of how many records are going through the tool.
  • Formula Library Additions:
    • Spatial Functions Category – over 20 new spatial functions have been added including calculations of area, bounding rectangle, centroid, distance, length, and others. These spatial functions can be utilized anywhere in Alteryx where formulas are used.
    • Finance Functions Category – financial analysis calculations (e.g. NPV; IRR; etc.) can now be natively added to Alteryx analyses (no need to export data to other applications to perform these calculations).
  • MetaCarta GeoSearch News Wizard – a new wizard is being added that will launch searches of MetaCarta's vast library of news feeds and will return the latest articles, blog entries, etc. for any topic in any defined geographic area.
  • Calgary Table Linking – new capability to link multiple Calgary data tables together for querying. Build one query that accesses multiple tables and brings back a combined result.
  • Module Dependencies – easily see and edit module data dependencies/paths for easy sharing and distribution of modules from one user's desktop to another.

Hope you enjoy the improvements we made to Alteryx. As always we welcome your feedback!

Tara

Tara McCoy

Tara McCoy is the Creative Director at Alteryx. Since joining Alteryx in 2004, Tara has held roles in Product Management, Content Engineering, and Community where her focus has always been on delivering an amazing product experience with Alteryx. From designing product icons and community badges, procuring excellent swag, concocting engaging contests, and crowdsourcing content from internal and external Alteryx advocates alike, Tara is dedicated to the Alteryx brand and wants everyone to experience the thrill of problem solving with Alteryx.

Tara McCoy is the Creative Director at Alteryx. Since joining Alteryx in 2004, Tara has held roles in Product Management, Content Engineering, and Community where her focus has always been on delivering an amazing product experience with Alteryx. From designing product icons and community badges, procuring excellent swag, concocting engaging contests, and crowdsourcing content from internal and external Alteryx advocates alike, Tara is dedicated to the Alteryx brand and wants everyone to experience the thrill of problem solving with Alteryx.