Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
How do I remove leading zeros from a field? Use the Formula Tool and the TrimLeft() function to remove leading zeros!
View full article
This article provides the instructions to address "Alteryx is not installed" error when installing Alteryx starter kits.
View full article
Upon configuring a Render Tool to output to a PowerPoint Presentation, the resulting file is corrupt.
View full article
Error “The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended” when both Use AMP Engine and Enable Performance Profiling is enabled in the Workflow Configuration Runtime tab
View full article
This document explains the steps to export HAR files by using Chrome Developer Tools built into Designer to investigate the interface of HTML GUI SDK tools.
View full article
[Simba] [BigQuery]131 (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions.'
View full article
Assisted Modeling tool will cause an exception if a data set is too huge. Anything around 40K is fine.
View full article
Status 500: Server Error UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 1049741870-255018 (1453348545)
View full article
Google Big Query v3.0 Input tool with ‘Service-to-Service’ authentication errors with "AttributeError: 'NoneType' object has no attribute 'message_types_by_name'"
View full article
When querying data with ROWID using Oracle OCI driver with the Input Data and Connecting IN-DB tools will result in the following errors: "You have found a bug".
View full article
Error being returned via the Select Tool functionality for field names with updated case type.
View full article
Certain maps are missing in the Base Map option after a recent Designer upgrade.
View full article
Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.
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
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
Running a cell in Jupyter Notebook containing Alteryx.read() returns "Unable to connect to input data" error. This happens if the workflow is saved in a file path containing an ampersand (&).
View full article