New output file every month

Question

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

ArtApa · Answer

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.

LogAA.yxzp

Analytics_Pooja · Answer

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

gabrielvilella · Answer

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

Log.yxmd