community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

Alteryx
Alteryx
Created on

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:
    • 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 list image.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.
  5. image.png

 

Additional Resources

 

Comments
Moderator
Moderator

Very helpful. Thanks @DaveF !

Alteryx Certified Partner

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

 

[]

Alteryx
Alteryx

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.