Engine Works

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

Prep and Blend

Output multiple excel files with multiple sheets based on 2...

Learn how to output multiple excel files with multiple sheets based on two different fields

Common Use Case

Utilizing CMS Physician Professional Fee Data as Benchmarks...

Creating benchmarks for clinical physician offices in the state of Pennsylvania, allowing physician to compare their billing practice to those of their peers.

Can the real [Field Name] please stand up...

My initial thought as I was staring at the simplicity of the solution in front of me was, "Wow, so simple, and yet so amazingly useful! How come I never realised this before?"

Platform | Product

Should I Stay or Should I Go?

Now that I'm WFH, I’m constantly asking myself why I decided to live in a four floor walk up with no A/C and a tiny balcony, when I could be a lot more comfortable with more space...

Developer

Solving Matt Parker’s Coin Puzzle in Alteryx

Matt Parker is publishing a weekly puzzle on his Think Maths website every Wednesday. This week’s puzzle was a Coin Puzzle - which felt like one that Alteryx would be well suited t...

Developer

JSON Build Tool

Do you interact with REST APIs? Do you format your data as JSON using multiple Alteryx Designer tools? If so, you should download the attached JSON Build tool. The JSON Build tool...

Apps and Macros

Introducing BB Date: Date Parsing for the Rest of Us

BB Date is the droid you're looking for. Introducing a new macro that automagically handles dates for you.

Alteryx for Good

Alteryx for Good with DataKindUK, Shared Assets and the Ecol...

Last weekend was the climax of nearly two months work as part of my Alteryx for Good project. This work has encompassed huge amounts of data preparation (particularly using open da...

Apps and Macros

The Cleanse Macro

People say you can spend upwards of 60% of your time “preparing” your data rather than analyzing it. Alteryx Designer has great, user-friendly tools to try to cut into that estimat...

Prep and Blend

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

Common Use Case

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