Creating a Fiscal Calendar / Week Number / Week Of Table

[eleealz]

Hello all,

This is my first post, and hope I can find the assistance I'm looking for.  I know this is a pretty simple problem, which I am able to do in Excel relatively easily, but am having a bit more difficulty with in Alteryx.

I would like to generate a table like below, where January 1st will always be considered day 1 of week 1, even if it makes the first week less than 7 days long.  This is an example of what the beginning of 2015 would look like, but I would like to dynamically generate this table for 3 years into the past / 3 years into the future.

Year	Week	Date	Week Of
2015	1	1/1/2015	1/1/2015
2015	1	1/2/2015	1/1/2015
2015	1	1/3/2015	1/1/2015
2015	2	1/4/2015	1/4/2015
2015	2	1/5/2015	1/4/2015
2015	2	1/6/2015	1/4/2015
2015	2	1/7/2015	1/4/2015
2015	2	1/8/2015	1/4/2015
2015	2	1/9/2015	1/4/2015
2015	2	1/10/2015	1/4/2015
2015	3	1/11/2015	1/11/2015
2015	3	1/12/2015	1/11/2015
2015	3	1/13/2015	1/11/2015
2015	3	1/14/2015	1/11/2015
2015	3	1/15/2015	1/11/2015
2015	3	1/16/2015	1/11/2015
2015	3	1/17/2015	1/11/2015
2015	4	1/18/2015	1/18/2015

Any help would be greatly appreciated. 

[joshuaburkhow]

This is a perfect use case for the "Generate Rows" tool.... hopefully this helps 🙂 

[PC19 · Accepted solution]

Borrowed this from another user and added a few things. You can certainly change it to fit your need.