Storing reports in month folders generated dynamically by Alteryx

Question

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!!!!

NikyN · Answer

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/td-p/73203

I am also attaching shared solutions!

Best Luck!

Niky

Storing reports in month folders generated dynamically by Alteryx.yxmc

Community Dynamic Folder.yxzp

arsh011 · Answer

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!!!

binu_acs · Answer

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