How to output the file to a latest subfolder in Alteryx

[jillv]

Hi,

I have monthly subfolders and would like to output the file to the most recent subfolder created. Could you please advise how?

Let's say I have, June, July, August, September subfolders.

When I run the workflow, I want the output to be saved to the most recent created folder, in this case to the September subfolder.

Thanks.

[IraWatt]

Hey @jillv,

Assuming the folder names are regular and standardised you can just use a formula like this for instance:

"C://Example File Location/"+DateTimeFormat(DateTimeNow(),"%B")+"/YourFile.xlsx"

This will always create a file location with todays month in using the date time functions + your file name at the ens.

With that just check these setting in the output data tool and it will always output to this months file:

If your interested in learning more about the datetime functions there is a great cheat sheet Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com