Alteryx Designer Desktop Knowledge Base

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

During run time of workflow, the following error is received:

How to Connect to Databases Outside of Alteryx.

This directory was generated by the Alteryx install script, and contains an instance of the Oracle Instant Client. Oracle Instant Client is a collection of installed Oracle Database libraries for connecting Alteryx Designer to local or remote Oracle Databases. There’s no need for tnsnames.ora file.

When a folder name starts with a period (.), the Input Data tool throws a "Can't find the file" error.

Data in Excel is corrupted and truncated when exporting data table that is larger than the default layout size set in the Render tool.

When your Python libraries don't work the way they should in Python tool, restoring the tool to it's original state could be the solution. This article walks through how to restore Python libraries and the virtual environment associated with the Python tool.

How to send emails on Designer using the Email Tool

What's the difference between Admin and Non-Admin installs of Alteryx? Stuff and things.

The SharePoint connector allows you to use Service Principal for downloading and uploading files, but it requires the Sites.All permission, which gives the user access to all the Sites in the tenant. This article describes how to set it up.

The article provides troubleshooting steps when "404 not found" error is encountered in Python tool.

When using a Python-based connector (e.g. Salesforce Input, Azure Data Lake File Input), an error message referring to CERTIFICATE_VERIFY_FAILED appears. With the new releases of the connectors tools there are three additional errors that can happen and can be resolved with these steps.

_CurrentField_ function does not work well if all the columns are not selected in the Table tool.

Alteryx for Excel Users

When trying to create a new dataset using PowerBi Tool, Designer shows 400 Bad Request error

Error: "Input Data (1117): Internal Error: Invalid parameter detected in function (null). File: (null) Line: 0 Expression: (null)." when pulling data from PostgreSQL

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

The caller workflow returns an irrelevant error message when the invoked workflow completes with warnings.

Opening an Excel binary file (.XLSB) in an Input Data Tool crashes Designer if Windows patches are not installed.

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

Information to know about connectors not connecting when a endpoint has Zscaler installed.