Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
When attempting to Write to MySQL with the output option "Update: Insert if New" you get an error if the table has a composite primary key of multiple fields and none of the data have changed in the row
View full article
During run time of workflow, the following error is received:
View full article
When trying to create a temporary table for use in the Data Input Tool (connecting to Google BigQuery) the workflow errors out with "Executing PreSQL: CREATE OR REPLACE TEMPORARY TABLE... Invalid query: Use of CREATE TEMPORARY TABLE requires a script or session"
View full article
When you try to insert a record to an Amazon Redshift table which has a column with attribute IDENTITY(seed, step), the record is inserted fine, but the value of the first column to be inserted is null instead of the value being passed into the Output Data tool.
View full article
A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.
View full article
When attempting to output to SQL table with only one column, the "No value column to update" error is thrown.
View full article
When using Amazon Redshift Bulk Connection, Output Data tool option "Size of Bulk Load Chunks (1 MB to 102400 MB)" is set to default when the Bulk Size value is higher than 4K
View full article
How to format common ODBC DSN-less connection strings
View full article
No Teradata Parallel Transport logs are being created when a workflow, that includes a Teradata Bulk Connection, is executed.
View full article
This article is written to provide an idea to output an excel sheet per data stream within one workflow using a batch macro.
View full article
Error "Failed to decrypt data: Key not valid for use in specified state." when trying to connect to data source
View full article
Corrupted Data when writing V_STRING, V_WSTRING, WSTRING to a CLOB using OCI or when writing V_STRING to a CLOB using ODBC
View full article
Adding or overwriting a worksheet in a workbook that contains a pivot table, corrupts the file and an attempt to repair the excel sheet removes the pivot.
View full article
This article explains the steps in configuring the Personal Access Token in Tableau Online server, in order to use this in Alteryx Designer for a successful PAT(Personal Access Token) based connection
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
View full article
API connections give access to many web-based applications, database systems, or programs by exposing objects or actions to a developer in an abstracted format that can easily be integrated into another program.
View full article
When doing Teradata bulk loader There's no difference between the two output options Append (Ignore Duplicate Rows) and Append (Mark duplicate Rows).
View full article
Connector tools that use "Sign in via Internet Browser" do not work correctly with Designer or Server 2021.3.2. To use those tools, you should upgrade to version 2021.3.3 or later and then download and install the tool version that says " Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 21.3.3.63061 or later.." Alternatively in the short term, you can use version 2021.3.1 of Designer or Server.
View full article
Nothing happens when clicking on the Save button when manually creating a connection string.
View full article