Alteryx Designer Desktop Knowledge Base

Running a cell in Jupyter Notebook containing Alteryx.read() returns "Unable to connect to input data" error. This happens if the workflow is saved in a file path containing an ampersand (&).

Jupyter Notebook fails to load after Flask package is installed.

Running workflow containing Jupyter Flow tool in Gallery fails if the server machine is not in a domain.

Python tool will not load Jupyter Notebook if the Detour tool is used and the path is diverted to another path where the Python tool is not on by default.

Alteryx.read() returns "attempt to seek past the end of the file" on an empty incoming data source

When using a python tool with pandas package, xlrd is unable to read .xlsx files, only .xls.

The code changes made in the Python tool will be lost after running the workflow immediately.

This article describes how to locate the Workbook.ipynb file behind the Python Tool in order to check access rights and resolve certain errors (most commonly, 404 errors).

This article will review how to acquire a System Info file to provide Support with more details about your local environment.

R tool is not able to read Chinese characters in column header/field names.

This article details on the steps to read/extract password protected excel file in Alteryx Designer using the R code.

How to fix an issue where the Python Tool Configuration Panel is blank

Custom tool not showing in tool pallette after installation.

Run Command

Steps for Harvesting Data in Google Big Query!

To find the full path and filename of a saved file in Excel, you use the =CELL function.

To assist you in your R adventures in Alteryx, we've developed a R Tool Cheat Sheet which you can download to have as your very own. This article reviews and explains the functions included in the Alteryx - R cheat sheet. 

SnakePlane is an abstraction layer that makes working with the Python SDK easy! This three-part tutorial breaks down building a tool using SnakePlane and SnakePlane Pilot.

Sometimes clients have asked how they can re-input the same excel file that they have just outputted into the same workflow. Normally, their gut instinct would be to open up a new workflow and start fresh with the updated file. However, this can be a bit cumbersome especially if they want to do this multiple times or for those wanting to do some sort of logging process in an app. Luckily, there is a quick and easy trick for this.