Alteryx Designer Desktop Knowledge Base

This error is displayed on current workflows with R and then if you put a new R tool on a blank canvas

Python tool doesn't show any results.

This article will walk through how to have different Module versions for different workflows. This example will use PyPDF2 as the Module

This article will review the method of creating a requirements text file that can be used to reinstall the same packages. Then a process to reinstall the same packages.

This article is part of the CS Macro Development Series. The goal of this series is to communicate tips, tricks, and the thought process that goes into developing good, dynamic macros.

If you are using a version of Designer≥2018.3, use the Python tool! If you are on an older version, this article is for you.

The Email Tool is a tremendously useful shortcut when it comes time to disseminate your analyses and other results straight from your workflow.

Macros can be designed to treat nearly every and any repeatable operation in Alteryx. If you’re working with formalized, established, processes and prefer not to duplicate work, or you’ve just found a handful of useful macros on our Public Gallery, being able to maintain macros is a must.

Truncated data is usually defined as numeric rounding or cut off, string shortening, or datum deletion - essentially any time information is lost.

There are a couple of different whitespace situations you might get yourself into, but this article has you covered in all of them!

how to export workflows with attachments

Any tool that performs a Sort will increase processing time. This article will show you how to improve efficiency!

How to Input .txt Files and Other File Types as Plain Text

The Fuzzy Match Tool provides some pretty amazing flexibility for string joins with inexact values – usually in the case of names, addresses, phone numbers, or zip codes because many of the pre-configured match styles are designed around the formats of those types of string structures. However, taking advantage of the custom match style and carefully configuring the tool specific to human entered keyword strings in your data can also allow you to use the loose string matching feature of the tool to match those values to cleaner dictionary keyword strings. If done properly, it can help you take otherwise unusable strings and, matching by each individual word, recombine your human entered data to a standardized format that can be used in more advanced analyses.

When you’re frequently writing and rewriting data to Excel spreadsheets that you use for Excel graphs and charts, it can quickly become a hassle to make and remake your reporting objects to keep them up-to-date so you’re visualizing the most recent data. A best practice to keep the hassle out of the process exists, though! If you keep your plots isolated to their own spreadsheet, referencing cell values in another sheet used to capture your data, you can simply overwrite the source data sheet and your plots will update automatically upon launching Excel. In the example below (attached in the v10.6 workflow Dynamically Update Reporting from Excel Spreadsheets.yxzp) we’ve included the workaround to make your Excel outputs seamless.

The 11.0 Tool Sheet is a handy reference document where you can view all the Alteryx tools and Macros included in the 11.0 Tool Palette. The tool sheet is attached to this article.

Full details on the addins can be found on my blog; the addins can be download from GitHub. Hopefully it will make creating some formulas easier!

Thanks to the brilliance of @RobertB during last year’s Alteryx Innovation Days, we now have a command line tool in beta that generates visual markup in the Designer to compare two workflows!

Looking for more premium connector and tool content to better equip your Alteryx platform for success? Check out what our partners have been up to!

An index for all the Alteryx Product technical specifications and system requirements!

An Unhandled Exception occurred when opening a workflow