Engine Works Blog

Under the hood of Alteryx: tips, tricks and how-tos.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
7 - Meteor

BEFORE_AFTER.PNGSome 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 change in balance every day. Meaning if you were to plot this data on a graph there would be gaps in the information for which there was no change. The way to solve this in Alteryx comes in two steps, first we need to identify exactly what dates are missing data and create rows for them in our dataset. Then we need to run calculations on this data to determine what the balance should be on the days that had no change.

Read more...

13 - Pulsar
13 - Pulsar
Alteryx Certified Partner
Alteryx Certified Partner

dude.PNGThis 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.

Read more...

Alteryx Community Team
Alteryx Community Team

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 template files. Alteryx ACE @patrick_digan has already shown (here) that this novel use of the Blob tools is in fact a great way to move files around in general, perhaps more straightforward and faster to learn that the traditional method of using the Run Command tool.

Alteryx Alumni (Retired)

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

Read more...

Alteryx Certified Partner
Alteryx Certified Partner

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

Read more...

Moderator
Moderator

we all start somewhere.png

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 which was created to help new users get started.

Read more...

Alteryx Certified Partner
Alteryx Certified Partner

Expert Vignette.gifIf 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 Dates, I'll provide you with some tools to better handle incoming date fields and help to teach you how to convert strings to dates.  Even with tools like the DATETIME macro, this can be challenging.  Hopefully, you'll avoid the frustration and skip directly to happily ever after.

 

Read more...

Alteryx
Alteryx

2018-05-29_1556.png

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

Read more...

Alteryx Community Team
Alteryx Community Team

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 Alteryx tool. Check out how we automated all the hard parts and brought the series to life!

Read more...

Alteryx Certified Partner
Alteryx Certified Partner

Money Time Value.png 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 tens, hundreds or thousands of variables with little to no effort?

Read more...

Alteryx
Alteryx

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

Read more...

Alteryx
Alteryx

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

Read more...

Alteryx Alumni (Retired)

DebugMacro3.png

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 need the Debug Macro.

Read more...

Alteryx Alumni (Retired)

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

 

Read more...

Alteryx Alumni (Retired)

The weekly exercises we are posting provide a great way for users to cross train and collaborate on different way to solve problems.  

Read more...

Alteryx
Alteryx

Inspired by my cranky five year old, I created a Mandelbrot Set renderer in Alteryx.

Read more...

Alteryx Alumni (Retired)

Larger workflows sometimes require a little extra effort to navigate around. We are exploring some enhancements to make it easier to move across a large canvas and we would love to hear your thoughts, suggestions, and concerns.

Read more...

Alteryx
Alteryx

Developing resource-intensive workflows can be a challenge when testing changes involves running the workflow through iterations that may take several minutes or more before being able to see results. This post walks through using the Cache Dataset macro to develop workflows in a smarter way, avoid repeated long run times, and speed up the process of blending and analyzing larger sets of data.

Read more...

Labels