Date to Weekend mapping

[RaghavanR]

Hi,

I have a requirement that I have values by date (including weekends like sat & sun). I want to summarise the total for the week on Friday.

In the below sample week. Data up until 31/12/2020 has to be added up and for that week, weekending has to be shown as 31/12/2020 as 01st Jan 21 is a holiday.

For the next week, data from 01/01/21 until next friday has to be added and shown against 07th Jan 2021.

I have yearly Bank holiday list.  

Can some one please guide me how can i do this in alteryx?

                    Input

28-Dec-20	Mon	10
29-Dec-20	Tue	20
30-Dec-20	Wed	30
31-Dec-20	Thu	40
01-Jan-21	Fri	50
02-Jan-21	Sat	60
03-Jan-21	Sun	70
04-Jan-21	Mon	10
05-Jan-21	Tue	20
06-Jan-21	Wed	30
07-Jan-21	Thu	40
08-Jan-21	Fri	50

Output

31-Dec-20	100
07-Jan-21	330

[messi007 · Accepted solution]

@RaghavanR,

please see below:

Attached the workflow,

Hope this helps,

Regards

[RaghavanR]

Thanks @messi007 for your quick help. Sorry I couldn't check it as I was  out of office for few days. Your solution worked for me. Thanks a lot again