Alteryx Designer

Definitive answers from Designer experts.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
When using a Python-based connector (e.g. Salesforce Input, Azure Data Lake File Input), an error message referring to CERTIFICATE_VERIFY_FAILED appears.
View full article
Fix Python tool installation error: An error occurred while installing package 'defaults::vs2015_runtime-14.16.27012-hf0eaf9b_1'. AssertionError()
View full article
When your Python libraries don't work the way they should in Python tool, restoring the tool to it's original state could be the solution. This article walks through how to restore Python libraries and the virtual environment associated with the Python tool.
View full article
Installing a package from the Python tool is an important task. In this article, we will review all the possible functionality included with the Python method Alteryx.installPackages().
View full article
With the Python Tool, Alteryx can manipulate your data using everyone’s favorite programming language - Python! Included with the tool are a few of pre-built libraries that extend past even the native Python download. This allows you to extend your data manipulation even further than one could ever imagine. The libraries installed are listed here - and below I’ll go into a bit more detail on what and why these libraries are so useful.   Each library is well documented, and there’s usually an introduction or examples on their sites to get you started on how a basic function in their library works.     ayx – Alteryx API – simply enough, we’re using Alteryx, sooo yea, kind of a requirement for the translation between Alteryx and Python.   jupyter – Jupyter metapackage – If you’ve used a Jupyter notebook in the past, you’ll notice the interface for the Python Tool is similar. This interface allows you to run sections of code outside of actually running the workflow, which makes understanding and testing your data that much easier. http://jupyter.org/index.html   matplotlib – Python plotting package – Any charting, plotting, or graphical needs you would want will be in this package. This provides a great deal of flexibility for whatever you want to visualize. https://matplotlib.org/   numPy – NumPy, array processing for numbers, strings, records, and objects – Native Python processes data in what some would call a cumbersome way. For instance, if you wanted to make a matrix, a.k.a. a 4x4 table, you would need to create a list within a list, which can slow processing a bit. However, NumPy has its own “array” type that fits the data in this matrix pattern that allows for faster processing. Additionally, it has a bunch of methods of handling numbers, strings, and objects that make processing a whole lot easier and a whole lot faster. http://www.numpy.org/   pandas – Powerful data structures for data analysis, time series, and statistics – This is your staple for handling data within Alteryx. Those who have used Python, but never pandas, will enter a whole new beautiful world of data handling and structure. Data manipulation within Python is faster, cleaner, and easier to code with. The best part about it is that the Python Tool will read in your Alteryx data as a pandas data frame! Understanding this library should be one of the first things to know when tackling the Python code. https://pandas.pydata.org/   geopandas – Extends the data types used by pandas to allow spatial operations on geometric types. Are you interested in geospatial analysis using Python? Try this package.  It makes working with geospatial data in Python much easier and faster.  http://geopandas.org/   requests – Python HTTP for Humans – for all the connector/Download Tool fans out there. If any of you are familiar with making HTTP requests (API calls and the like), then you should introduce yourselves to this package and explore how Python performs these requests. http://docs.python-requests.org/en/master/   scikit-learn – a set of Python modules for machine learning and data mining – Welcome to the world of machine learning in Python! This library is your go-to for statistical and predictive modeling and evaluation. Any crazy and wild methods you’ve learned for machine learning will most likely be found here and can really push the boundaries of data science. http://scikit-learn.org/stable/   scipy – Scientific Library for Python – all your scientific and technical computing can be found here. This library builds off the packages already installed here, like numPy, pandas, and matplotlib. Dealing with mathematical models and formulae are usually located within this library and can help provide that higher level analysis of your data. https://www.scipy.org/   six – Python 2 and 3 compatibility utilities – For those who are unfamiliar, Python versions come in 2 forms, version 2.x and 3.x (with 3.x being the most recent). Now, even though Python 3 is supposed to be the latest and greatest, there are still many users out there who prefer using Python 2. Therefore, integration between the two is a bit tricky with syntax differences, etc. The six module provides functions that are usable between the two so everyone can remain calm and happy! Their documentation is usually coupled with which version the functions most closely align to, so a user can get a better idea to its functionality. https://pypi.org/project/six/   SQLAlchemy – Database Abstraction Library – SQL in Python! Covers all your database needs from connecting to and extracting data, allowing it to interact with your Python code and thus, Alteryx itself. https://www.sqlalchemy.org/   statsmodels – statistical computations and models for Python – This library builds off sci-kit learn but focuses more on statistical tests and data exploration. Additionally, it utilizes R-style formulae with pandas data frames to fit models! https://www.statsmodels.org/stable/index.html   These are the libraries installed with the Python Tool, which can do almost any data function imaginable. Of course, if you’re looking to do something that these libraries don’t provide, there are myriad other Python libraries that I’m sure will help you with your use case. Most of these are also well documented in how to use so search away and let your mind float away in the beautiful cosmos created by Python.
View full article
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.
View full article
Python: ModuleNotFoundError: No module named 'ayx'   When running a workflow using the Python tool, you may see the error below:   ModuleNotFoundError: No module named 'ayx' The error may appear when running your code interactively in the Jupyter notebook:   It may also appear when running your workflow     Environment   Product - Alteryx Python Tool   Cause   This error occurs when the ayx module that is required for Designer's integration with Jupyter notebook cannot be found. It may have been overwritten by other modules installed by the user.    Solution   Follow the steps in the article below to reset your Python tool to its original state. This article will walk you through re-installing the required packages using the requirements.txt file included with Designer. Reset the Python tool
View full article
Issue   Saving or running the workflow in the Designer causes the following error to occur:   An Unhandled Exception occurred. A previous action may not have completed successfully. Click OK to send the development team the error log so that we can fix this error in a subsequent release.   Environment   Alteryx Designer   Diagnosis    Checking the logs from %PROGAMFILES%\Alteryx\ErrorLogs\AlteryxGUI shows the following error:   Alteryx Designer x64 - 2019.2.5.62427 Type: System.ArgumentException Message: Cannot have ']]>' inside an XML CDATA block. Source: System.Xml OS Version: Microsoft Windows NT 6.2.9200.0 OS Is x64 Capable: True Selected Plugin: LockInGui.LockInSelect.LockInSelect Processor: Intel(R) Xeon(R) CPU E5-2676 v3 @ 2.40GHz Private Memory: 380923904 -------------------------------------------- at System.Xml.XmlTextWriter.WriteCData(String text) at System.Xml.XmlElement.WriteElementTo(XmlWriter writer, XmlElement e) at System.Xml.XmlElement.WriteContentTo(XmlWriter w)   Cause   The use of "]]>" in the following tools (not an exhaustive list) causes the error: Formula tool Filter tool Report text tool R tool Python tool   Solution   Avoid using "]]>" in the tool or escape the ">" to ">".
View full article
FAQ: Getting started with Jupyter Notebook     What is Jupyter Notebook?   Jupyter Notebook is an open-source application used for statistical modeling, machine learning, data transformation, and other data science purposes. The application is also referred to as Jupyter. The notebooks can contain documentation read by users, executable code such as Python that is run for data analysis, as well as the results of an interactive session. Notebooks can include output such as HTML, images, video, and plots. Notebooks are processed by a computational engine called a kernel.   Starting in release 2018.3 the Python Tool includes a customized version of Jupyter that allows you to run Python code directly in Alteryx Designer. Because it is used within the constraints of Designer, some options may not behave the same as a standard online Jupyter Notebook. For details see the Python Tool Help Page: Python Tool.   What if I cannot configure a Jupyter notebook in the Python Tool?   Try clicking on any blank space on the workflow canvas, then back on to the Python Tool to make it available for configuration. It may be necessary to do this several times if the Python Tool is not responding at first. Each time you do this, the Python Tool attempts to connect to Juypter again.   A proxy server is blocking use of Jupyter notebooks what should I do?   When proxy credentials are needed for Designer, the username and password can be configured by clicking on the Options menu and selecting User Settings, Edit User Settings, Advanced tab, and then Proxy Settings.     If that does not resolve the issue, you can try clicking in the Windows Search bar, type Internet Options, and press the Enter key. On the Connections tab, click the LAN Settings button. Check the box for “Use a proxy server for your LAN”, and then enter the proxy server address and port. Also, check the box for “Bypass proxy server for local addresses”.     If a proxy auto-config (PAC) file is in use, you may need to check settings in the file as it defines how web browsers and other user agents can automatically choose the appropriate proxy server.    What if Jupyter Notebook is still not working?   Check to see if a jupyter_server.log file exists in the Alteryx default temporary folder. To locate this folder, click on the Options menu and select User Settings, Edit User Settings, and then the Default tab. For more information, please see: How To: Obtain Web Configuration (Jupyter) Logs for the Python tool.   Is connection debugging available?   Yes, try enabling the CEF Developers Tools using the instructions listed here:Debugging the CEF. Afterwards, add a Python tool to the Designer canvas and check the Console tab in the AlteryxCEF DevTools window that appears. This should verify if there are any errors connecting to Jupyter.     How can I avoid caching issues with notebooks?   If you open 2 separate instances of Designer for testing each with a New Workflow1 workbook, and the Python Tool as tool #1, the notebook would get shared between both workflows. To avoid this issue, save each workflow with a unique name.   What if I get a File not found error?   Try saving the workflow and running it again as listed in the Python Tool Mastery article on Community.     Additional Resources   Python Tool  Tool Mastery Python  Jupyter Notebook Quick Start Guide  Python Tool Doesn't Show Any Results or Errors on Run  Python Tool Libraries - An Introduction to Python  How To: Use Alteryx.installPackages() in Python tool   How to reset the Python tool   
View full article
What happens when one installs the YXI file of a Python-based tool in Alteryx Designer.
View full article
How to handle metadata with Python tool.
View full article
Python Tool Doesn't Show Any Results or Errors on Run   When running the Python tool in Alteryx, the output is blank, and no results or errors are shown.   Python may have been previously installed by another app (e.g., Anaconda)   Environment   Product - Alteryx Designer   Diagnosis   To ensure the issue is with the Python tool in Alteryx, create a simple 2-tool workflow with test data and code as below. Click Run in the Python tool and verify the tool returns no output and no errors.   Step 1 - Run the workflow with a Text Input Tool and Python code as below   Step 2 - Verify that the Alteryx engine reports no errors     Step 3 - Verify that the Browse tool shows no data available   Cause   The IPython kernel being called by the Jupyter Notebook may be referencing a previously installed or non-existent Python binary, rather than the Python binary installed with Alteryx.    Solution   Open an Administrator Command Prompt and navigate to: Admin Version of Alteryx: C:\Program Files\Alteryx\bin\Miniconda3\PythonTool_venv\Scripts Non-Admin Version of Alteryx: %LocalAppData%\Alteryx\bin\Miniconda3\PythonTool_venv\Scripts Enter the command: jupyter kernelspec list  Navigate to the directory returned in step (2) in a File Explorer. If you have multiple directories, repeat steps 3-4 for each directory. Open kernel.json in a Text Editor and verify that the first item in the argv list references the python.exe in the same directory as the directory from (1) or simply "python" in cases where the directory from (1) is included in your PATH Environmental Variable. To test if you have a valid argument, you can simply try entering the argument in a command prompt and it should open a Python shell.   Additional Resources   Jupyter Troubleshooting
View full article
How to find the logs of Jupyter, web interface of Python tool
View full article
Alteryx Designer comes with tools (based on both R and Python) to create and use predictive models without needing to write any code. But what if you've got custom models written in R or Python outside of Designer that you want to use in Designer, or vice versa?
View full article
If you are using a version of Designer   ≥  2018.3, use the Python tool! If you are on an older version, this article is for you.    Below is an example demonstrating the use of the Run Command tool to execute a Python script in the Designer and use its output in the workflow:     For a Python script, your Command should be Python.exe. If the directory where Python exists is in your system path variable, you can simply type Python.exe. Otherwise you will have to give it the full path, keeping in mind to quote the string if there are spaces (e.g. "Program Files"). In Command Arguments, you will type the location of your Python script (Alteryx's default working directory is the directory of the running module so it may be easiest to keep your script in the same folder to simply type "your_python_script.py" rather than the full path) and any - or -- options necessary. Remember to quote this string!   The example script from the attached simply sends text to a text file to be used as input for the Designer (note: it will not run unless you have configured your python environment 😞                                                                                                                 As you can see, we’ve successfully executed a python script and used the Read Results input to bring the result of the script into the Designer for further processing.
View full article
The Python tool interface is based on a Jupyter Notebook. As of Alteryx Designer 2018.4, the Python tool can create logs for its web configuration. The frequency of these logs can be increased by switching on the debugging log level. Note that output file will be bigger and that it will impact Python tool performance in Designer.  
View full article
With the release of 2018.3 comes the long-awaited and highly anticipated Python Tool! This article is a general introduction to using the tool.
View full article