Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Error opening "SHOW VARIABLES LIKE 'aurora_version'" when connecting to MariaDB via ODBC.
View full article
Using SQL Server connections, "date" datatype fields are changed to "V_WString"
View full article
Outputting to SQL Server by the Output Tool option "Create New Table" resulted in CREATE TABLE Permission Denied.
View full article
Receive "ERROR: The session is read-only" using pre/post SQL option in the Input Data tool when attempting to perform any operation that is not a select statement, such as dropping/creating tables
View full article
The guide covers SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, CROSS JOIN, WHERE BETWEEN, WHEREIN, DISTINCT and we hope you find it helpful.
View full article
Alteryx provides GUI tools that offer similar functionality to many SQL commands. Although minimal SQL scripting may be necessary in order to properly configure tools, the amount required to complete analysis is significantly reduced.
View full article
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.
View full article
How to dynamically add data into workflows using the Dynamic Input Tool
View full article
Quick Connect: Internal-Error-Unable-to-add-new-Alias-to-the-Alias-Manager
View full article
Workflow worked in versions before 2020.3 After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord"
View full article
User gets a Win32 Exception when trying to connect to a database or edit a query
View full article
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.
View full article
The Run Command tool can be used to connect to SQL Server and run complex SQL statements as well as multiple stored procedures.
View full article
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.
View full article
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.
View full article
In SQL, you can join on a range, using code similar to the below snippet
View full article
Let's talk about how to replicate the WHERE EXISTS functionality of SQL within Alteryx.
View full article
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.
View full article
User is getting a "missing dll" or "file not found" error when writing spatial data using the bulk loader
View full article