Alteryx Designer Desktop Knowledge Base

This article covers how to delete records from a database using an Input Text tool containing a parameter and a macro using the Post SQL Statement. The macro below is an example of how you can do this.

How to dynamically add data into workflows using the Dynamic Input Tool

Quick Connect: Internal-Error-Unable-to-add-new-Alias-to-the-Alias-Manager

The quoted and none options do not work when using In-DB tools.

Workflow worked in versions before 2020.3 After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord"

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

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.

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

How do I create an index on a field in my database table? An index for a field can be created using the Post Create SQL Statement option (option #10) found in the Configuration window of the Input tool.

Alteryx has the ability to create and query Pre and Post SQL statements. Using this feature is good if you need to create a temporary table, delete or update the table before running the select. With this, you also have the ability to run stored procedures (via exec stored_procedure;) before and after the actual query as well.

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.

Error while connecting to a database, from the Input Data Tool - Error: Input Data (13): Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

User is getting a "missing dll" or "file not found" error when writing spatial data using the bulk loader

"Error: Input Data (1): Error opening connect string: Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.\08001 = 18" after upgrading SQL Server to 2019 and disabling TLS 1.0 and 1.1

SQL Server read performance is slow in Designer.

This article will help you work around the error and actively log in

How to download and install SQL Server ODBC drivers.

Error: "Must declare the scalar variable '@var_name'" when running PL/SQL in Pre or Post SQL Statement Section.

This KB outlines the workaround for DE18888 where Cyrillic characters from DB2 are not displaying in Designer

Alteryx doesn't read some unicode characters correctly