Engine Works

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

Alteryx Designer

Using Alteryx to Scaffold Your Data

Data scaffolding is a method of filling in missing data in order to help with analysis, particularly when building out certain types of visualizations.

Designer Cloud

6 min to read

Designer Cloud and Reporting: Coffee & Tea Sales

Let’s use Designer Cloud & Reporting to solve the weekly challenge 363.

Alteryx Designer

3 min to read

Sports Analytics in Alteryx: The Commentator's Guide to Cric...

Cricket is one of the most popular sports in the world, so we wanted to use the world's most popular analytics tool to help us analyse it!

Alteryx Designer

4 min to read

Automating the Analytical Review of COREP Reports with Alter...

Internal control is part of a strict regulatory framework applicable to all banking institutions. Using Alteryx, we were able to carry out within a major European bank the control...

Alteryx Designer

2 min to read

Building a Workflow in 5 Minutes

Ready to start building Alteryx workflows? Check out this post!

Alteryx Designer

5 min to read

McLaren Formula 1 Simulator: Using the Right Tool for the Jo...

How we used Alteryx to create a demo for our McLaren Formula 1 simulator.

Common Use Case

3 min to read

RegEx for the Win: XML Tag Clean-Up

I want to show you all how easy it is to remember a simple syntax that can really help you clean up your data.

Alteryx Designer

3 min to read

How to Create Merged Cells in Reports Part 3

So you have finally decided to create a report with both merged row cells and merged column cells! Brave.

Alteryx Designer

6 min to read

Exploratory Data Analysis in Alteryx

The data is not always (almost never) perfect, so it is necessary to verify its quality. This article will cover the various tools and methods that can be used for EDA in Alteryx.

Prep and Blend

4 min to read

How to Dynamically Remove Columns with Zeros or Nulls from A...

Recently, I learned how to remove columns with zeros or nulls from Alteryx workflows using the Auto Field tool, and I want to show you how easy it is.

Prep and Blend

2 min to read

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

6 min to read

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.

2 min to read

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

5 min to read

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

4 min to read

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

5 min to read

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

8 min to read

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

8 min to read

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

3 min to read

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

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

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