Build a Table that Links to a Column in another Table

Question

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:

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

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

Deed Transfer Records Cleaned.yxdb

mdsalmankhan89 · Accepted Answer

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