Save output File the same location as the input file

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.

Workflow

Accepted answers

atcodedog05

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/87489

Hope this helps 🙂

All comments

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 😀👍

in out filename.yxmd

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703