Mapping/Aggregating US and CAN holidays to Weeks

[wonka1234]

Hi,

How can I map these values to weeks?  My weeks seem to be every monday of the year.. but what if a holiday is on a friday? Ie Good Friday.. How can I include this in my mapping?

Thanks

[FrederikE · Accepted solution]

Hey @wonka1234,

You could use the Generate Rows tool to include all dates and then do it. 

See the attached wf.

[wonka1234]

@FrederikE  thank you. is there a way to get it back to the weeks? lol

[FrederikE]

Hey @wonka1234,

You can use:

DateTimeFormat([Dates],"%w")

To get the number of the weekday (Monday =1). And then filter on it again.

But ofcourse then you loose the individual daily information again - not sure what you want to have there.