Engine Works

Under the hood of Alteryx: tips, tricks and how-tos.

Grand Prix

Alteryx Grand Prix Recap

Last week, SRC held its annual Extend user conference at the Omni Resort in Broomfield, Colorado. This year we put on an Alteryx Grand Prix to showcas

Apps and Macros

1 min to read

Regression Testing

How do we build & test Alteryx? Thanks to Linda, we have a nice script that runs the Alteryx build every night, but building it is not enough. We

Prep and Blend

2 min to read

Mod

I had the pleasure of helping test a module for the Alteryx Grand Prix and learned a number of things. But the most interesting? Mod.Mod?Mod.Wikipedia

Developer

1 min to read

UTF16 not Unicode

I have been spending a lot of time lately working on Unicode issues. Mostly I have been making our older products like Allocate & Solocast fully work

Release | New Feature

2 min to read

Alteryx 5.0 Planning Survey

Last week I sent an email to our Alteryx users asking for participation in a short survey to help us plan and prioritize features for the 5.0 release

Release | New Feature

1 min to read

New GeoJSON format in Alteryx

One of the latest additions to Alteryx, available in an upcoming beta release, is the ability to express spatial objects as variable length strings. T

Alteryx Designer

1 min to read

Replicating tasks... there is always an easier way!

General rule of thumb...anytime you find yourself having to replicate what seems to be the same process, there is an easier way to automate it. Rec

Common Use Case

2 min to read

Custom odd/even row coloring in the Table tool

Have you ever had a table where you wanted to use odd/even row coloring, but wanted the grouping to vary based on the data? Perhaps you have a field i

Common Use Case

4 min to read

Saving Private Snippet*

Have you ever wanted to build pieces of a report, and then save them somewhere for later use? Perhaps you have a boilerplate portion of a report, and

Release | New Feature

1 min to read

Alteryx 4.1 is shipping this week!

SRC is pleased to announce the release of Alteryx version 4.1. The goal of this release was to tighten up the program, fill in some missing functional

Release | New Feature

1 min to read

Thank You!

So Alteryx 4.1 is just about to ship and it is the best release yet. I'd like to interrupt this blog to thank the people that made it happen. Once

Release | New Feature

2 min to read

Amazon EC2

Have you heard about cloud computing yet? Mostly the term is referring to things like Google Docs that you can use online potentially replacing Office

Alteryx Tools

4 min to read

The All New Omnibus Wholly Integrated Tabular, Spatial, Snip...

Ok, so that's a bit much.But the new Browse tool in Alteryx 4.1 is almost (almost!) that cool.The first thing to note is that there is now just one Br

Common Use Case

1 min to read

Fun with the Table Reporting Tool

The new reporting tools provide great flexibility in generating a report. The majority of reports I create generally contain tables that have static c

Alteryx Designer

2 min to read

You've Got Mail

I am a fan of automated processes. Repeated processes should definitely be automated. Even though I don't want to have to push the button(s) to make i

Alteryx Designer

2 min to read

Generalizing spatial files with Alteryx

The problem:Detailed spatial files look really good when zoomed in. Zoom out far enough with a large enough file and you'll need to run for a cup whil

Release | New Feature

1 min to read

Useful and Fun

I have talked about Alteryx being fun, but it can also be useful for the most interesting things. I added the color picker control to the Report/Map t

Release | New Feature

57 sec to read

The Summarize Tool is the Way to Go

During my time at SRC, the question of how to combine multiple (10+) spatial objects into 1 object has been posed several times. Everyone's initial

Release | New Feature

1 min to read

Wall Calendars with Alteryx

Although generating tabular output is easy, and generating maps is easy, generating temporal output is, well, challenging. So with this in mind, I too

Release | New Feature

2 min to read

Keep it Lean

You know the scenario, you have to solve a newly identified business problem now. In fact, it needs to be completed yesterday. You throw something tog

Alteryx Designer

2 min to read

Planning Your Next Event, Let Alteryx Help

If a watched pot never boils then a camped-on module surely takes its time to complete. Or at least it feels that way as I stare at my monitor, watchi

Release | New Feature

2 min to read

What's New With Spatial Database Integration

Input/Output Tools: For the next release of Alteryx, I have been creating a new option for ODBC Spatial Connections. This will allow spatial objec

Common Use Case

1 min to read

Smoothing out sparse data

Have you ever had the problem where your data has lots of irregular holes, but that missing data is actually important to you? The Generate Rows tool

Apps and Macros

57 sec to read

Got Pain? Try a holistic approach... Macros

Have you ever pondered how we QA Alteryx? With over 70 processing tools that support hundreds of functions, just about any file type, field types, and

Common Use Case

2 min to read

Alteryx is Fun

I've had a bunch of customers tell me how much fun they think Alteryx is to use. One even had her coworkers describe it as "that cartoon program." Obv

Common Use Case

2 min to read

Ad-Hoc Spatial Data Analysis

I recall this day in school where the professor was drilling into our heads "select … from … where … Anyone? Anyone? Anyone seen this before?" Oh wait

Common Use Case

1 min to read

Small to Big Fuzzy Matching

I was working with a client who has a contact database with 500 million records. Once a month or so they have a smaller dataset to add to their growin

Release | New Feature

1 min to read

Alteryx version 4.0.2.1

Dear Alteryx User We at SRC hope you are enjoying all of the new features and enhancements that were implemented in Alteryx version 4.0.2.0. One of

Common Use Case

2 min to read

Calgary Cooled My Heels

As a recovering DBA I still reach into my bag of tricks when having to do low level data movement. It's a habit hard won, but I'm breaking it. And Ned

Release | New Feature

33 sec to read

Alteryx Team Blog

Welcome to the Alteryx Team Blog The Alteryx Development Team has started a team blog and we'd like to share the content with you. We have set up t