Creating a Yearly Log File

[clarrock]

Hi

Here are two sample alteryx outputs for Monday and Friday

Alteryx Output for 4th September 2020 - 

DATE	ITEM ID	COLOUR
2020-09-04	68	Red
2020-09-04	56	Red
2020-09-04	98	Red
2020-09-04	32	Red
2020-09-04	45	Blue

Alteryx Output for 7th September 2020

DATE	ITEM ID	COLOUR
2020-09-07	687	Red
2020-09-07	562	Red
2020-09-07	984	Blue
2020-09-07	321	Blue
2020-09-07	456	Red

The Alteryx Workflow/Output runs from Monday to Friday.

How do I create a log file with different Sheets (Red and Blue) which only takes in counts of Reds and Blues on a Friday run Alteryx Output and not Monday to Thursday Alteryx Outputs as shown in below sample :

Log File.xlsx  - Sheet Name  - 'Red'

DATE	RED COUNT
2020-08-14	3
2020-08-21	1
2020-08-28	2
2020-09-04	4

Log File.xlsx - Sheet NAme - 'Blue'

DATE	BLUE COUNT
2020-08-14	2
2020-08-21	4
2020-08-28	2
2020-09-04	1

Also once the year in the Alteryx Output changes to 2021/2022/etc - the log file should delete all the previous rows/records and start with a fresh row as such

Log File.xlsx  - Sheet Name  - 'Red'

DATE	RED COUNT
2021-01-01	3

Log File.xlsx  - Sheet Name  - 'Blue'

DATE	BLUE COUNT
2021-01-01	2

[clarrock]

@grazitti_sapna thanks for the workflow, but I can't output

I get an error : Sheet must exist

Here are my configurations for flag=1 filter

 

Here are my configurations for isnull(Date) filter - I can't see any option like yours to Overwrite sheet or range - only theres Overwrite Sheet (Drop) and Overwrite Sheet (Remove).. Which one should I select?