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 ...
  • AlexisOlson's avatar
    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.