Alteryx Designer Desktop Knowledge Base

Upon configuring a Render Tool to output to a PowerPoint Presentation, the resulting file is corrupt.

The external Python environment must use Python version 3.8.5. Using another version will not work in the Jupyter Flow tool.

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.

A mismatch of timezone in Windows setting and registry can cause Assisted Modeling tool to fail

Need notes

Status 500: Server Error UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 1049741870-255018 (1453348545)

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"

Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.

Input-Data-Tool-does-not-retrieve-all-the-rows-from-a-table-or-view-when-connecting-to-SAP-HANA.

Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.

Error when choosing Options > Advanced Options > System Settings: Method not found: 'Void AlteryxGuiToolkit.Dialogs.Licensing.ManageLicenses.ShowLicensingDialog(System.Windows.Forms.Control, Boolean, Boolean)'

Error: "An unexpected error occurred" when performing an Offline License Activation in Designer.

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.

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.

A video walkthrough for the setup and configuration of the Microsoft Dataverse connector, which has succeeded the Microsoft Dynamics CRM connector.

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.

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.

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.

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%

Exporting data from the Browse tool to a CSV file cannot display/convert the double-byte characters correctly.

This article is written to provide an idea to output an excel sheet per data stream within one workflow using a batch macro.