New output file every month

[Analytics_Pooja]

Hi Alteryx users

I am creating a workflow where I am trying to generate a log file. The log file gets appended with a new row every time the workflow runs. 

I want to create a new log file every month and the data gets appended to the same file if the workflow runs multiple times in a month. 

Any lead will be much appreciated.

Best

Pooja 

[gabrielvilella]

Hi, I believe you can have something similar to this.

[Analytics_Pooja]

Thanks for your reply @gabrielvilella  . This solution works only if monthly file already exists. I also want the workflow to create the file first. 

Best

Pooja 

[ArtApa]

Hi @Analytics_Pooja - In this case you'd need to check if a file exists and use a Detour tool and a Macro. I change the previously uploaded workflow to achieve this.