Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cross join tables

Hi!  I need help cross joining two tables.    I have one table that looks like this:  Table "Openings hours"   Store Weekday Hours open Store 1 Mo 8 Store 1 Tu 7 Store 1 We ...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    In the Query Editor, you can merge Opening Hours table onto the Dim Date table joining on Weekday and then expand the Store and Hours open columns.

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
5 years ago

Anonymous , 

Step 1: Join the two tables based on the Weekdays. 

Step 2: Then drag the Stores, date, and hours open from the respective tables on Table visual.