Engine Works

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

Alteryx Designer

Update SharePoint Drop Down Lists Using Alteryx Tools

Over the last few months I've been working to automate a process that was slow and fraught with error. So, it's getting a makeover using Alteryx.

Alteryx Tools

7 min to read

How to Generate and Format Totals and Subtotals

Overview of the main techniques for creating the different types of vertical or horizontal, totals or subtotals, and how to format them.

Alteryx Designer

8 min to read

What Are Reference Shortcuts? (And Why You Should Be Using T...

Reference Shortcuts are a hidden gem in Alteryx.

Alteryx Designer

10 min to read

Four Methods to Consolidate Files

Going far in the automation of loading often raises small problems. Here are the 4 methods to manage EVERYTHING. From the simplest to the most powerful.

Alteryx Designer

5 min to read

How to Cancel Manual Jobs in Alteryx Server

Cancel manual jobs in Alteryx Server using a workflow.

Alteryx Designer

9 min to read

Creating a Custom SQL Query Builder App

How to create a Custom SQL Query Builder App and some suggestions for customizing it for your own database querying uses!

Best Practices

12 min to read

DateTime Functions Cheat Sheet

In an effort to help those drowning in datetime waters, I did my best to make a concise overview of the datetime functions that Alteryx offers and try to get you going in the world...

Alteryx Server

9 min to read

Alteryx Server - Gallery API Postman Collection

In this article, we are going to review what the Alteryx Gallery REST API is, what resources are available, and how to use it with Postman.

6 min to read

APIs for Beginners - Integrate All the Systems!

Do you wish that your Alteryx workflows could automatically pull the latest data into your workflow so that you can schedule them on Alteryx Server without manual intervention?

Alteryx Designer

5 min to read

7 Alteryx Best Practices to Simplify Your Life

Use these strategies to reduce re-work, confusion, and speed up your development time.

Alteryx Designer

4 min to read

Alteryx Analytic Apps Introduction and Deep Dive Series: Par...

Start with the data.

Tips and Tricks

2 min to read

30 Tips in 30 Minutes

Join Alteryx ACEs Esther Bezborodko and Joe Lipski for a fast-paced, exciting session of tips, tricks, shortcuts, timesavers, performance improvements, and more.

Apps and Macros

5 min to read

Mask by Pattern - How to Alter the XML of a Workflow at Runt...

With this option, we are able to dynamically recreate tools in our workflow, change their parameters, or perform different approaches based on business criteria. There is no limit!

Design Patterns

4 min to read

The Alteryx Feature You Wish You Knew About – XML View of Wo...

As I have continued on my path and learned more about automation, macros, apps, and even creating my own tools, one feature is a must-know for this – XML VIEW OF WORKFLOWS!

Common Use Case

3 min to read

Filling in the Blanks: Correcting Missing Values in Daily Ba...

Some finance processes in the tax world require you to monitor the balance of various accounts over time. The problem is, just like your personal bank account there isn’t always a...

Tips and Tricks

6 min to read

Data From Home

Have you ever been stuck at home for days on end with an Alteryx license and nothing to do? Do you ever find yourself wishing you could just grow your own data at home?

Best Practices

4 min to read

This Feature That You Didn't Know About Will Change Your Lif...

Working horizontally, is not the best way to travel in Alteryx. It’s like horizontal running in real life. It just isn’t as effective…

Platform | Product

2 min to read

40 Tips in 40 Minutes

This video is for all of you in the audience in Sydney that couldn't take notes fast enough to jot down every single tip. And it's for everyone else, too.

Developer

23 sec to read

Excel Templates with Blob Tools

Joseph Serpis (@JosephSerpis) has a great new post over on Intersections and Overlaps that shows how to use the Blob Input and Output tools to save you time with your Excel templat...

Alteryx Server

4 min to read

An Introduction to Troubleshooting Alteryx Server

Following these steps will help find the fastest resolution to an Alteryx Server issue.

Best Practices

3 min to read

Become “Lightning” Fast in Alteryx Designer!

Tips & Tricks from an Alteryx ACE on how to develop Alteryx workflows as quickly as possible.

Platform | Product

3 min to read

We All Start Somewhere

As an experienced Alteryx user, it can be easy to forget that there is a learning curve for many folks just starting out. This article takes a look at a new Designer Cheat Sheet wh...

Best Practices

7 min to read

MarqueeCrew's Guide to Avoiding Date Frustration

If you google (a verb) "Date Frustration," the 7th article is Date Conversion Frustration - Alteryx Community. As a follow-up to my previous blog post, Marquee Crew's Guide to Date...

Predictive Analytics

2 min to read

CavMis Model – Predicting the FIFA 2018 World Cup Without Be...

Following up on their recent webinar, Shaan and Nick predict the World Cup winner.

Developer

5 min to read

Behind the Scenes of the Tool Mastery Series: Community APIs...

Recently we celebrated the launch of our long anticipated Tool Mastery Series, a collective of Knowledge Base articles tasked with communicating the most inspired uses of each Alte...

Tips and Tricks

4 min to read

For the Love of Formulas

For the love of formulas; why would you take the time to configure many formulas and risk errors in the process when you can rely on a known set of formulas and dynamically create...

Developer

3 min to read

REST APIs Part 2 - Authentication

Key words to look for when authenticating to a REST API within Alteryx

Alteryx Tools

9 min to read

I Am The Developer Toolset (And So Can You!)

Think the Developer toolset isn't for you? Think again. Start using these tools and change the way you are building workflows.

Apps and Macros

5 min to read

Step Into The Debug Macro

Who needs the Debug Macro? If you're building macros in Alteryx, YOU need the Debug Macro. If you're not building macros in Alteryx, you need to build macros in Alteryx. And you ne...

Tips and Tricks

3 min to read

Canvas Navigation in Alteryx 10.1

Alteryx 10.1 includes new controls to make it easier to navigate around the canvas with large workflows.