Alteryx Designer Desktop Knowledge Base

By combining Alteryx and Microsoft Power BI, organizations can streamline and accelerate the process of preparing and analyzing data. This provides a faster way to deliver an end-to-end experience for data access, preparation, analysis, visualization and consumption — delivering deeper business insight faster with a more complete set of data.

Having trouble reading or writing Microsoft Access files? No worries - Client Services is here to help!

Sometimes you may have daily, weekly, monthly or yearly data dumps where you want to only run the most recent file. Within Alteryx you can make this process dynamic and seamless through the use of a few tools.

Web scraping, the process of extracting information (usually tabulated) from websites, is an extremely useful approach to still gather web-hosted data that isn’t supplied via APIs. In many cases, if the data you are looking for is stand-alone or captured completely on one page (no need for dynamic API queries), it is even faster than developing direct API connections to collect.

How to connect to a Dropbox or Box.com account from Alteryx on your desktop

how to dynamically rename headers on multiple files in a directory

Getting the error: "not enough fields in record" from the Input Data Tool

In order to open Access databases with the .accdb extension, you will need to download the Microsoft 2010 Office System Driver: Data Connectivity Components.

Why am I getting the error "InvalidArgument=Value of '0' is not valid for 'itemIndex'. Parameter name: itemIndex" when trying to load an Excel file in and Input tool?

Can I read in an Excel file located ina zipped archive file from Amazon S3?

Instructions for reading multiple CSV files at once!

Every so often we get questions about a .tde (Tableau Data Extract) file that is being output from Alteryx that has a file size of 30k when the original data is much larger. When the file is opened in Tableau this error sometimes comes up: An error occurred while communicating with data Source ‘yourfilename.tde’

When using Excel spreadsheets in Alteryx, sometimes there may be difficulty in reading the data. Viewing the spreadsheets in XML format is an excellent way to check for encoding or formatting issues.

Error connecting to Office 365 using the Sharepoint Input tool - "The sign-in name or password does not match in the Microsoft Account system", when the user tries to connect to Sharepoint from the Alteryx Designer

Quick Connect: Internal-Error-Unable-to-add-new-Alias-to-the-Alias-Manager

Error reading CSV files using AMP Engine

SAP HANA Field Description

Reading and Writing spatial data from/to Redshift

Display issues when reading data with unicode characters from Oracle

Fixed decimals values in Alteryx results in Null values and report the following error: Input data (1):not a valid FixedDecimal. FixedDecimal values ​​must be of the form: -nnn.nn

Here is a simple tip to create a Text Input tool with multi-line records.