Alteryx Designer Desktop Knowledge Base

In this article, we demonstrate how to import multiple worksheets from one Excel file, how to import multiple worksheets from multiple Excel files, and how to import a specific range of cells from an Excel sheet.

Welcome to the addictive world of predictive analytics. We have the perfect platform for you to start exploring your data.

A frequent use case we get asked about is how to join two data sets on a date range where one data set has a start date field and an end date field and the other dataset has a just a date field.

This article is part of the CS Macro Development Series. The goal of this series is to communicate tips, tricks, and the thought process that goes into developing good, dynamic macros.

A relative path is in relation to the location of the App on the users system. Check out our examples of how and when to use them!

Common commands used with Alteryx Designer and Server

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

The Inviso Macro Pack!

Is it possible to add a comment to an expression used in a Filter or Formula?

How to install two versions of Designer on the same machine.

ORA-12154: TNS: could not resolve the connect identifier specified

When using the download tool with an SFTP or HTTPS connection, you may receive the error - Error transferring data: failed initialization. This often occurs when Designer can't agree on a cipher suite to communicate with the host server.

How to find the relevant information and configure a Databricks connection through the Manage In-DB Connections window. The Databricks connection includes bulk loading capabilities that allow users to load large data sets faster. 

Modifying the Jupyter Notebook creates a new temp directory and document instead of updating the existing workbook.ipynb file in the already created temp location.

When installing the Alteryx License Server, it may fail with an error with setting up the service. This issue can be resolved by reinstalling the Java Runtime Environment on the machine.

Error SQLExecute: Internal Query Processor Error: The query processor could not produce a query plan. For more information contact Customer Support Services.

Image Template tool is not loading the PDF file in the configuration window for a specific formatted PDF file:

Creating Dates from Excel Date Formatted as Number

One of the best things about Alteryx is the ability to read in multiple files very easily and automatically combine them into a single dataset. This becomes a bit trickier when dealing with files that have different schemas or Excel files with multiple tabs. Adding both multiple excel files with multiple tabs, and having the schema change within each tab takes it to another level.

Step by Step guide to support users to connect to Snowflake through Alteryx, from downloading the driver to data.

This article covers how to use Run Command events to run a workflow.