Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating a Fiscal Calendar / Week Number / Week Of Table

eleealz
5 - Atom

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.

 

YearWeekDateWeek Of
201511/1/20151/1/2015
201511/2/20151/1/2015
201511/3/20151/1/2015
201521/4/20151/4/2015
201521/5/20151/4/2015
201521/6/20151/4/2015
201521/7/20151/4/2015
201521/8/20151/4/2015
201521/9/20151/4/2015
201521/10/20151/4/2015
201531/11/20151/11/2015
201531/12/20151/11/2015
201531/13/20151/11/2015
201531/14/20151/11/2015
201531/15/20151/11/2015
201531/16/20151/11/2015
201531/17/20151/11/2015
201541/18/20151/18/2015

 

Any help would be greatly appreciated. 

2 REPLIES 2
joshuaburkhow
ACE Emeritus
ACE Emeritus

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

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
PC19
5 - Atom

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

Labels