Save output File the same location as the input file

[iceshock]

Hi all.

I will be running the alteryxflow monthly and the input file will location will be different everytime (updated accordingly via creation date) . How can I overwrite the input file with the output file that I have produce on each alteryx run.

regards.

[atcodedog05]

Hi @iceshock 

Here is what you can do. 

Configure Input tool to get the full path

It pulls in full path, filename and sheetname

And in output tool configure it to change path based on filename.

Make sure output option is overwrite.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

_

[iceshock]

hi,

may i check with you, if i were to have this workflow to pick up the latest file via creation date, how should i go about configuring to attain a similar workflow as yours? 

[atcodedog05 · Accepted solution]

Hi @iceshock 

In the first formula tool you are creating the file full path to load it into dynamic tool to read.

So what you can do is, you can use an append tool to join back the file path after dynamic tool. And take it forward till the output tool.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Append-Fields/ta-p/874...

Hope this helps 🙂

[iceshock]

ty so much. it really helps

[atcodedog05]

Happy to help 🙂 @iceshock 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂