Storing reports in month folders generated dynamically by Alteryx

[arsh011]

I have created a workflow that generates reports in excel format, but I want to store them in month wise folder when the workflow runs in January its stores the report in the January folder, and when month changes it creates a new folder dynamically to the next month and stores the reports in next month without overwriting the data, how we can do that and how we can achieve using Alteryx reporting tools . Thanks, and Please help!!!!

[binuacs]

@arsh011 https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-Folders-and-Sub-folders-in-it/t...

[arsh011]

Thanks, man!! but I am generating 100 excel files using grouped by condition on a specific column, when I create a folder dynamically it clubs all the excel files in a single file in different sheets, I need separate files just in a folder. how we can solve this problem. Please help!!!

[NikyN]

Hello @arsh011,

I believe you are looking for this: 

There is already solution posted

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-create-a-dynamic-output-folder/... 

I am also attaching shared solutions!

Best Luck!

Niky