Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
"I have a bajillion files that I need to bring into my workflow... wayyyyyy too many for me to use individual Input Data tools! What's the best way to do this?"                    - every Alteryx user ever
View full article
What problems does DCM solve, what are its limitations, how does it differ from Server Data Connections, and what are syncing and sharing connections and further recommendations.
View full article
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. In this part, we demonstrate how to read in multiple files with different schemas using a Batch Macro.
View full article
32bit Access driver fails when attempting to map in a new file. Existing workflows continue to run.
View full article
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.
View full article
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!
View full article
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.
View full article
This article discussed about the Alteryx Connectors deprecation, for initial set of connectors, and clarifies the questions around the Connectors deprecation.
View full article
Error: "You have found a bug. Replicate, then let us know. We shall fix it soon." when pulling data from Snowflake.
View full article
Input Data tool connected to SAP HANA database is not pulling all records it should be for the specified Query.
View full article
If there is already a selected stored procedure in the SQL Editor tab, clicking on the Stored Procedures tab in the “Configure Pre/Post SQL statements and Stored Procedure” window will throw out “Unable to find stored procedure ” where the name of the procedure is incorrect.
View full article
API connections give access to many web-based applications, database systems, or programs by exposing objects or actions to a developer in an abstracted format that can easily be integrated into another program.
View full article
This error is typically thrown when trying to read a file that does not match the selected File Format, but also in rare cases, from a corrupted file.
View full article
When trying to read data from Hive, the error: "SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis" is thrown in the server while executing a query.
View full article
How to obtain and install the driver and setup ODBC connection DSN connection
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
ERROR: "General error; 1033 error while parsing protocol" while connecting to SAP HANA DB using the Input Data Tool in Designer
View full article
How to Edit Environment Variables for Oracle Data Connection
View full article