ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Python Tool Doesn't Show Any Results or Errors on Run

DaveF
Alteryx Alumni (Retired)
Created

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

image.png

 

Step 2 - Verify that the Alteryx engine reports no errors

 

image.png

 

Step 3 - Verify that the Browse tool shows no data available

image.png

 

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

 

  1. Open an Administrator Command Prompt and navigate to: NOTE - For versions 2019.4 and up to 2021.1.4 (but not including) the PythonTool_venv was renamed to Jupytertool_venv. Then in 2021.1.4 and higher it was renamed to DesignerBaseTools_venv
    • 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
  2. Enter the command: jupyter kernelspec listimage.png
  3. Navigate to the directory returned in step (2) in a File Explorer. If you have multiple directories, repeat steps 3-4 for each directory.
  4. 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. You can also include a direct path to the python.exe if changing PATH Variables is not an option for you similar to this path (C:\Program Files\Alteryx\bin\Miniconda3\PythonTool_venv\\python.exe  (Admin version), or %LocalAppData%\\Alteryx\\bin\\Miniconda3\\PythonTool_venv\\python.exe (Non-Admin))
  5. image.png

 

Additional Resources

 

Comments
JakeS
Alteryx
Alteryx

Very helpful. Thanks @DaveF !

geraldo
11 - Bolide

Hi,

 

For the browse tool to display something on channel # 1 you have to put the following code.
if it's a dataframe
Alteryx.write (data, 1)

This will have output 1

 

[]

DaveF
Alteryx Alumni (Retired)

Hey @geraldo - thanks for catching that! I fixed the screenshot. This article is actually showing an uncommon environmental setup when the data won't show up in #1 because Jupyter is looking for python in the wrong place, and how to fix it.