Python Tool Alteryx.write() error

[lrhodig]

Hello,

I'm using the Python Tool to create a dataframe from some .xlsx files, and I am trying to use Alteryx.write() to get this dataframe into the rest of my workflow.

Everything looks fine with the dataframe:

But when I try to run the workflow, with Alteryx.write(df, 1) as the final step,  I receive the following error:

Cached data unavailable -- run the workflow to make the input data available in Jupyter notebook (C:\Users\luker\Documents\alteryx_projects\activations_by_industry\monthly_reports_ws\1_xlsx_files\jupyterPipes.json)

There's no input data going to the Python Tool though - the workflow is just a Python Tool and a Browse Tool - so I'm not sure why this error is occurring. I'd appreciate any help!

[joshuaburkhow · Accepted solution]

Looks a bit similar of an issue to this post https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Python-tool-Alteryx-read-and-Alteryx-w...

[lrhodig]

Thanks!

Taking out os.chdir() and instead using the full file path to define the dataframe did fix this problem.