Alteryx Designer Desktop Knowledge Base

User is trying to use LENGTH to determine the length of a value and getting an error.

User is getting an error with Union In-DB tool: Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException Schema of both sides of union should match.

User gets a Win32 Exception when trying to connect to a database or edit a query

User is getting the error "Detour tools in macros must terminate within that macro" when trying to use a macro in a workflow

User is getting an error when loading data to Snowflake using the local bulk loader option with an Internal Named Stage.

This article explains how to correct Designer event status if it does not update.In the Designer Workflow-Configuration Window, on the Events tab, there is a checkbox option: Enable Events.

An OCI error may occur when running a workflow from a network location with many OCI inputs: OCIEnvCreate Error: No error handle available to report exact OCI_ERROR.

This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.

how to get started with jupyter notebook

How to get started with iterative macros

How to get started using Batch Macros

When you have a repetitive task to complete processing data across different columns, data sources, and/or workflows, a Standard Macro may help automate that task.

Most people using Designer will only install the Alteryx Predictive Tools. These tools do not need additional software other than Designer. The Microsoft R Client Predictive Tools require a separate Microsoft R Client installation.

Exception handling may be needed so that a scheduled workflow continues even if a pre or post Oracle SQL statement has an error.

How to troubleshoot Predictive Tools or R-Tool missing in Designer

This article will help you configure Gallery workflows to use temporary files in the Engine’s staging directory for e-mail attachments or output.

For problems with Windows not launching Designer or displaying an error message, the Program Compatibility Troubleshooter may help.

Characters that are not on a standard English keyboard may need translation into Unicode or a language-specific code page for Designer and database drivers to read them correctly. Characters with incorrect encoding will often appear as boxes or question marks in the Designer Results screen and error messages. Unicode characters take more bytes than English ASCII characters. Changing the column type and increasing the column size may be needed. In Designer, the column size is the number of characters, not the number of bytes.

Errors and warnings occur when predictive model names contain spaces

When importing data from an SAP HANA database, a conversion error from VARCHAR1 to ASCII may occur. 

The Run Command tool can be used to connect to SQL Server and run complex SQL statements as well as multiple stored procedures.