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.
Status 500: Server Error UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 1049741870-255018 (1453348545)
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
Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.
View full article
Input-Data-Tool-does-not-retrieve-all-the-rows-from-a-table-or-view-when-connecting-to-SAP-HANA.
View full article
Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.
View full article
Error when choosing Options > Advanced Options > System Settings: Method not found: 'Void AlteryxGuiToolkit.Dialogs.Licensing.ManageLicenses.ShowLicensingDialog(System.Windows.Forms.Control, Boolean, Boolean)'
View full article
Error: "An unexpected error occurred" when performing an Offline License Activation in Designer.
View full article
Designer crashes after closing the first workflow with a Connect In-DB tool and Browse In-DB tool and then creating a 2nd workflow with the same tools.
View full article
Error: "The following fields are not updatable members of the target table" received when performing an update to a record with the Salesforce Output Tool. The column is locked for editing by your Salesforce Administrator or is the incorrect primary key to reference for updating the record.
View full article
A video walkthrough for the setup and configuration of the Microsoft Dataverse connector, which has succeeded the Microsoft Dynamics CRM connector.
View full article
When Alteryx creates a query determined by an In-DB workflow, if the workflow includes a Join In-DB tool, Alteryx aliases the tables to be joined as "Left" and "Right". These are reserved words for some databases.
View full article
Image Input tool fails with the "unable to open " error if the length of the path (including filename) exceeds 260 characters in Windows 10 and Server 2019. However, there is no issue in Server 2016. All have long path enabled.
View full article
Designer installed in double-byte characters (Japanese) named folder fails to load the tool palette when the Japanese language is used in Designer. Tools palette loads fine in other languages though.
View full article
When using the Intersect tool to compare the same spatial information between an MRR file and a GRD file, the MMR is showing an offset, when the overlap should be 100%
View full article
Exporting data from the Browse tool to a CSV file cannot display/convert the double-byte characters correctly.
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
Alteryx.write() returns "XmlParse Error: the attribute "type" is missing“ if there is a double-quote in the column name and the double quote is followed by a space and more characters.
View full article
Installing a package from the Python tool is an important task. In this article, we will review all the possible functionality included with the Python method Alteryx.installPackages().
View full article