Alteryx Designer Desktop Knowledge Base

The Alteryx Starter Kit for Human Resources contains improperly configured Drop Down tools in the Analyzing Employee Satisfaction sample workflows for all languages other than English

Error: Can’t find the file: “[path\FileName]”. Make sure the file path is correct. Error text being revised from Error: File not found "[path\FileName]"

This article provides an overview of all things Alteryx licensing. This includes our prerequisites for installing and licensing Alteryx, an overview of different ways to activate, links to helpful guides and how to best administrate your keys once activated.

How to push spatial data into a PostgreSQL database in the proper format

When starting Alteryx Designer the below error is received: There was an error while loading: Object reference not set to an instance of an object.

Publish hyper file to Tableau Server 2020.2 or Online does not contain Number OF Record field. This might cause the the views/dashboards be broken.

Received the error "Error in PDF Rendering. Error Number: 4119: FILE OPEN ERROR" whenever using Table Tool or Render Tool.

Workflow worked in versions before 2020.3 After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord"

Querying a date from the Alteryx Server Persistence MongoDB using the MongoDB Input tool can be tricky since Alteryx Server dates are stored as string values. Here is how to use regex in the criteria section of the MongoDB Input tool.

When connecting to a DB2 Database via ODBC in Designer, some Date datatype from a column are coming up Null

Error: "FATAL: password authentication failed for user" when PostgreSQL or Greenplum credentials contain special characters when connecting in Designer.

This article is an extension to the community article "Scheduling as a copy in the Scheduler DB vs On Disk", and is specifically aimed for Designer + Desktop Automation installations only.

Troubleshooting the error InboundNamedPipe when writing out a .hyper file from an Output tool or the Publish to Tableau Server tool

Troubleshooting : "Start Here" and other Default Settings reset on opening Designer

Understand and troubleshoot the error "Login failed for user" when connecting to an OleDB datasource

Understand and troubleshoot the "No error handle available to report exact OCI_ERROR" error message

Troubleshoot and solve the Hive error message "Syntax or semantic analysis error thrown in server while executing query."

This KB explains how to query views with the Google BigQuery Input Tool

refer to the article for examples

We frequently get questions about how to flag rows in a  data set that are missing values in any column.  \n  \n In the example below, we will demonstrate how to add a new column to the data that gives a count of null or empty values per row. The end result will give a count of 1 to each of the highlighted rows in the image.  The new column can be used in a filter tool to isolate rows of data that have missing values.

If you are developing with Alteryx's In-Database tools you may want to share the workflows with users who do not have as much database experience. Below is an example workflow to create amacro that will allow your users to select which fields are brought out of the in database tools without interacting with the in database tools directly.