Alteryx Designer Desktop Knowledge Base

In SQL, you can join on a range, using code similar to the below snippet

Let's talk about how to replicate the WHERE EXISTS functionality of SQL within Alteryx.

Installing and using Interface Designer

how to import multiple Excel ranges at once

Why can't we read an Excel file when it's open?

I am getting a Conversion error when trying to summarize a number with a comma in it.

12 Use Cases for RegEx

A common error we see in Support is: "The temp drive is getting full. Free up some disk space or cancel." Here's how to fix it!

When you're setting up your Macro Input tool, make sure to use the Field Map option and add '(Optional)' next to the field names you don't want to be required!

Ever been confused about whether you should use a Join tool or a Union tool? This article explains the differences and use cases for each tool. 

Oracle database character set is AL32UTF8. The field defined is VARCHAR2. Writing back some Chinese characters to this field using OCI ends with garbled characters.

Error: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

32 bit connections no longer supported in 21.3.

Ever wish you had an easy way to read in data to Alteryx Designer from your Quickbooks Online account? Well, now there's a tool for that. This article will describe how to make an API call to QuickBooks Online through the QuickBooks Input Tool attached to this article. 

Email tool error "Failure when receiving data from the peer" for a specific 'from' address

Adding macros as relative paths

This article provides steps to connect to Redshift from Designer.

When sharepoint lists have date fields, they are off by the UTC current timezone set in sharepoint.

Alteryx Partners leveraging the Designer API via .NET should not upgrade to Alteryx Designer 11.8, 2018.1, or 2018.2 because doing so will render API integration inoperable. The issue will be addressed in Alteryx Designer 2018.3 (expected GA end of August 2018) at which time users can safely upgrade.

What is the delimiter when writing In-DB via HDFSC

The Visual Query Builder comes up empty for Teradata Database.