Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
Hi, Can you please explain Date Dimension script ?
or can you provide an example about what exactly you are looking for.
Ashutosh
Combining two date columns from two different tables.
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.