Alteryx Designer Desktop Knowledge Base

How do I remove leading zeros from a field? Use the Formula Tool and the TrimLeft() function to remove leading zeros!

This article provides the instructions to address "Alteryx is not installed" error when installing Alteryx starter kits.

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

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

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.

Text Pre-processing tool fails when no row of data is passed in.

Assisted Modeling tool will cause an exception if a data set is too huge. Anything around 40K is fine.

Error being returned via the Select Tool functionality for field names with updated case type.

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 (&).

Excel Binary file appears to be corrupted when multiple worksheets are created.

Using Python tool with AMP engine result in the loss of the Jupyter notebook (404 : Not Found), reverting to E1 makes the user code disappear (open a new instance of the Notebook).

Python tool will not load Jupyter Notebook if the Detour tool is used and the path is diverted to another path where the Python tool is not on by default.

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().

If the workflow path contains a "&", Python tool will fail to load. 404: Not Found will be seen.

When trying to license Alteryx Server on a Windows 8 based computer , the user receives the error "An internet connection is required for activation. Please connect to the internet and try again, or contact customer support. Contact your license administrator for help with licensing. Defect TCPE-196

Alteryx.read() returns "attempt to seek past the end of the file" on an empty incoming data source

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.

When user tries to input CSV file that has delimiter character encapsulated in quotes (so that it should not be considered a delimiter), connector will not consider the file valid.

Error: "Windows Security patch prevents the Jet driver from reading .xls files; install the 2010 32-bit Access driver" when loading an Excel .xls file

The ODBC connection error "Netsuite ODBC Connection Error "[NetSuite][ODBC 64bit driver][OpenAcess SDK SQL Engine]You have entered an invalid e-mail address, password or context (AccountID, RoleID) information" occurs when connecting to NetSuite via a Input Data tool.

This article is for how to fix the error for registration only loading the c# headers in Designer.