Create new excel file and append data each time till month end then create new and repeat

Question

I need to Create an excel file for each month and append rows into that file on every day and at the end of the month it should create new file for that month and repeat the same process again.

Currently when I select the option to "Append to existing Sheet" it throws error that the file doesn't exist. I am using 2023.1 version.

Shubh07kr · Answer

Hi @Qiu, thanks for your reply. In my case start date of the month is not fixed. Suppose that if 1st of the month is holiday then the start of the month will be different, not 1st.

Qiu · Answer

@Shubh07kr 
It happens to true that the Control Container was introduced from 2023.1 version.

So we get the current Date, then check if it is the 1st of the month or not then decides which Control Container will be activated after a Filter tool.
Note that the AMP engine (Alteryx Multi-threaded Processing) needs to be enabled.
https://www.theinformationlab.nl/en/2023/06/05/alteryx-2023-1-control-containers-explained/

0428-Shubh07kr.yxzp