Category Archives: Alteryx

Fuzzy Joins for Grouping Values Into Buckets

At my company we often work with panel data and need to be able to easily group individual panelists into buckets or profiles.  On a recent project I needed to identify which panelists were Light, Medium, Heavy or Extreme buyers … Continue reading

Posted in Alteryx | Tagged | Leave a comment

Calculating Correlations and R Squared Values with Alteryx

I’ve been busy on a bunch of big projects lately as you can probably tell by my neglected blog.  Today I tried a new tool and thought I’d share how it works and how it can be improved on using … Continue reading

Posted in Alteryx | Tagged , , | 3 Comments

Dynamic Field Renaming in Alteryx

In my work at TABS Analytics, I often find myself building re-usable alteryx workflows for processing sales data coming from syndicated sources such as Nielsen or IRI.  The goal is to build tools that can be applied to data coming … Continue reading

Posted in Alteryx | 1 Comment

Building a Fill Down Macro in Alteryx

Anyone working with Excel data inevitably encounters the situation where data needs to be “filled down” to blank rows below values. Suppose, for example, that you wanted to convert this data:               Into this:

Posted in Alteryx | Tagged , , , | Leave a comment

Alteryx 10.0 Review

I just upgraded to Alteryx 10.0 today and wanted to share my findings.  Overall the upgrade was quite seamless though they do require an uninstall of the prior version effectively preventing true side-by-side comparisons on the same box.  Below are … Continue reading

Posted in Alteryx | Leave a comment

Spreading Time Periods with Alteryx

One challenge most data integrators eventually face is the need to spread data down to different time periods.  This could mean spreading weekly data down to days, or  multi-week events down to individual weeks.  This can be challenging with traditional

Posted in Alteryx | Tagged , | Leave a comment

Hacking Alteryx – Editing XML Directly

Ok, ok, maybe this isn’t technically hacking, but it sure feels like it!  While at the Alteryx Inspire conference this year I learned that you can actually access the XML behind any workflow tool effectively bypassing the GUI entirely.  Granted, … Continue reading

Posted in Alteryx | Tagged , , | 2 Comments

Alteryx Inspire 2015 Highlights

I just got back from a great week in Boston at the Inspire conference.  It was exciting being around 800+ other data enthusiasts, though I have to say it was humbling too, seeing all the great work everyone else is … Continue reading

Posted in Alteryx | Leave a comment

Automate Populating Select Lists in Alteryx

In today’s post and video I’m going to share a quick way to rapidly populate the select tool in Alteryx if you need to change the data type or rename a bunch of fields in your data stream.  While Alteryx’s … Continue reading

Posted in Alteryx, Excel | Leave a comment

Converting Data Types in Alteryx

One of the most common tasks in any ETL project is converting data types.  When data begins in the form of a text file or (even worse) a formatted excel file, one often has to load the data as text … Continue reading

Posted in Alteryx | Tagged , | 2 Comments