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.
Solved! Go to Solution.
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 😀👍
_
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?
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.
Hope this helps 🙂
ty so much. it really helps
Happy to help 🙂 @iceshock
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂