1 Reply Latest reply: Oct 16, 2015 4:40 AM by Olly Bond RSS

    Add a Date Dimension Column to a Project

    Jean-Charles Peyrondet

      Hy watchers,

       

      I want to add to my project a Date Column.

      My project is now connected to a DataBase Source with already a Date column

      The new date is comming from a simple Excel File looks like this :

      Date

      01/01/2015

      02/01/2015

      03/01/2015

      ...

      31/12/2018

       

      Because in my exports, Monarch show me with a Current Week Filter, only the day of a sales , but there are not column for the rest of the week

       

      Monarch Exports if we are Thursday :

      Product  |  Monday | Thusday | Total

      TV          |    100     |    50        | 150

      Radio     |       15    |    25        |  40

                                                     |  190

       

      What I want if we are Thursday :

      Product  |  Monday | Thusday |  Wednesday  |  Thursday  |  Friday  |  Saturday  | Sunday |  Total

      TV          |    100     |    50        |     "empty"      |   "empty"    | "empty" | "empty"    |  "empty" |  150

      Radio     |       15    |    25        |      "empty"     |  "empty"     | "empty" | "empty"    |  "empty" |   40

                                                                                                                                                    |  190

                                                   


      I try a Right Outer Join with my DataBase Date Table and my Excel Date Table. (In Data Prep Studio)

      But I can't switch to Monarch Classic with my new column created.

       

      Am I in the right way ?

       

      Thks