Use python to read values that are in workflow

[arakshe]

Does anyone know if there's a way that I can make it so that the python within Alteryx takes the filepath from the formula tool which is called Output_filepath and is, so that I don't have to manually change the file path for each file that I download into the folder. Can I directly use the values within the workflow in the script? How should I change my code?

[apathetichell]

delete your second photo --- it includes your basie auth in the formula tool. 

[apathetichell · Accepted solution]

short is --- yes... just read in your alteryx data stream to the python tool. import pandas. assign your alteryx to a new df and use look for ['Outputfilepath'] in your dataframe.

from ayx import Alteryx
data=Alteryx.read("#1")

test=data['Output_Filepath'][0]
print(test)

[arakshe]

Thankyou so much!