Python tool running the wrong code

John_A_ZA

Hi all

I have not seen this problem posted anywhere else but I have a workflow with 2 python tools in it. If I cache the one python tool (the earlier one in the process), the second python runs the code of the cached tool.

To give an example similar to what i am doing, the first python tool is pulling a list of products from an API. The next python tool will then call a different API to get all transactions for each product. The problem is if I cache the this python tool that pulls all the products, the next python tool which is supposed to pull all the transactions suddenly changes and becomes the first python tool in that it pulls all the products.

The code is completely different between the two tools, so there should be no way for the second tool to be able to run the code of the first tool.

What is even weirder is if I save to the server at this point, then when I run the workflow on the server, the second python tool is still a clone of the first python tool and provides the wrong information. Has anyone else come across this? 

philipmannering

I've seen this happen, I think because the jupyter notebooks (.ipynb files) are saved in a temp folder, Alteryx gets a little confused with which notebook relates to which tool ¯\_(ツ)_/¯. This seems especially true when copying and pasting Python Tools.

As painful as it is, I think the most robust resolution is starting a new workflow. Dropping new Python Tools on the canvas and copying and pasting the correct code into each one. ....i.e. starting again. Further, I always recommend copying the and pasting the code into a Comment Box, just in case it goes missing...