Build a Table that Links to a Column in another Table

[amcgill2]

Hi Alteryx! I am a new user to the Alteryx community and am learning how to use this tool. I need to:

Create a workflow to build a Record_Date_Dimension table that links to the recording_date column in the Deed Transfer Records Cleaned Table. It needs to meet the following requirements:

1. The dimension should cover the date range from 1999-01-01 to 2020-12-31
2. The dimension should have the following attributes
   1. Year
   2. Month (in number, 1, 2,...)
   3. MonthName (in name, January, February,...)
   4. Day
   5. Weekday (in number, 0, 1, 2,...)
   6. WeekdayName (in name, Monday, Tuesday,...)
   7. DayOfYear (i.e., 1-366)
   8. Quarter (Jan-Mar =Q1, Apr-Jun =Q2,...)
   9. YearMonth (e.g., 2020-02)
   10. YearQuarter (e.g., 2020-Q3)

Any help is greatly appreciated! Thank you for helping me learn this!

[mdsalmankhan89 · Accepted solution]

Hi, 

May I suggest you to have a look at DateTime Functions | Alteryx Help while you are working with dates. It is always helpful for me. 

Attached is a workflow to generate a date dimension and I just pushed in the generated "date-keys" into your data feed. Hopefully it will help. 

Just for fun, you can explore further & use interface tool to ask user to input start and end date while generating the date dimension. 

Best Regards,

Salman