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.
Solved! Go to Solution.