Schedule/RunPython Script using alteryx

Hello All,

I created a python script in vscode and want to run/schedule this python script using alteryx.

I got this post from the community

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Run-a-python-script-in-Alteryx/td-p/10973

As per the above post,I've tried running the script using "run command" tool but it's giving me the error as "error code 2". although my script works fine when I'm running it in Vscode terminal.

Wanted to try "Python" tool but it my script does not have any input or output also it's not integrated in Jupyter Notebook.

Could you please advise.

swapsingh

Custom Tools

Python

Accepted answers

All comments

CathyS_Slalom

Hi @swapsingh2712 , In order to use the python tool, you would need to read the data first and connect the python tool. Click the python tool, you will see the configuration window below, you can click the menu --> Alteryx to import script/notebook. After that read the data using df = Alteryx.read('#1'), the data you read in will be stored as pandas df. If you have multiple data want to use, you can read as df2 = Alteryx.read('#2')

aduval

Hi @swapsingh2712

I use Alteryx to trigger python only scripts using this method.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Python-Code-Tool-Script-Runner-Macro-Code-Injection/td-p/419146

It allows you to input a script to run and does not have to be a Jupyter notebook.

Let me know if you have any other questions when trying to get it working. I would be happy to help you troubleshoot.

- Adam

swapsingh2712

@aduval Thank you so much for suggesting this macro. but for some reason, I'm getting the below error when trying to run the original macro

"Python (10) ---------------------------------------------------------------------------¶FileNotFoundError Traceback (most recent call last)¶<ipython-input-3-4b0cb414fd18> in <module>¶ 44 ¶ 45 code_path = os.path.join(workflow_dir, folder, script_file)¶---> 46 exec(open(code_path).read(), globals())¶FileNotFoundError: [Errno 2] No such file or directory: '\\\\Mac\\Google Drive\\Alteryx\\Python Iris Clustering\\Python Iris Clustering Analysis\\_python\\Python Iris 2.py'¶"

Do I have to make any changes to the code?

I've already updated my path and file name and connected it to macro, but it's giving me below error

" Python Script Runner (1) Tool #10: ---------------------------------------------------------------------------¶NameError Traceback (most recent call last)¶<ipython-input-3-4b0cb414fd18> in <module>¶ 44 ¶ 45 code_path = os.path.join(workflow_dir, folder, script_file)¶---> 46 exec(open(code_path).read(), globals())¶<string> in <module>¶<string> in Download_Report_Files(ENV, ReportName, FolderPath)¶NameError: name '__file__' is not defined¶

Please advise
"

swapsingh2712

@aduval : Yes I tried and it's running the print statement. It's failing whenever the script is trying to open the browser.

I tried modifying my script to run Google Chrome in headless mode, but due to my company network restrictions, the authentication is not going through.

Any suggestion how to run it in alteryx without using the headless mode?

aduval

Sorry. I don't have any current experience with that specific use case.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703