How to create Date Dimension

[Rajitha1]

Hi Team,

      I have two tables with no common column. Two tables having date columns, without joining the tables need to create Date dimension.

Thanks,

Rajitha

[AshutoshBhumkar · Accepted solution]

Hi,

You need to somehow connect those two tables in order to get the data on selection.

Create a Bridge table with Dates from both the tables, Alias it as DATE and connect both the tables using DATE column.

E.g:

Table 1

ID, SalesDate,Sales

SalesDate as DATE

Table2

Customer,OrderDate,OrderValue

OrderDate as DATE

Bridge

SalesDate   as DATE  from Table1

Concatenate

OrderDate  as DATE    from Table2

Please provide some sample data for better understanding.

Hope this helps.

Thanks,

Ashutosh

[Rajitha1]

Hi @AshutoshBhumkar  as you said i.e. okay but i need Date Dimension script.

Thanks,

Rajitha

[AshutoshBhumkar]

Hi, Can you please explain Date Dimension script ?

or can you provide an example about what exactly you are looking for.

Ashutosh

[Rajitha1]

Combining two date columns from two different tables.

[AshutoshBhumkar · Accepted solution]

The example I provided below will combine two DATE columns from two different tables.(Bridge)

Now, when you select DATE on the sheet, records from both the tables will be shown.