Forum Discussion

ruserty's avatar
ruserty
Regular Visitor
9 years ago
Solved

MATCH between 2 tables !!!Please!!!

  Hello! I have 2 tables from Google Analytics and I want to match them to be able to filter data based on criteria from 2nd table.  In the 1st table I have "Date", "Sessions", "Transactions", cust...
Need Help
  • ketan10's avatar
    ketan10
    9 years ago

    Hi ruserty

     

    You could  carry out the following steps:

    1. Click on New Table under the Modeling tab
    2.  Create a table name: CalendarTable = CALENDARAUTO(). This would give you a new unique date column in CalendarTable

    3.  Go to the Relationships tab and create a one to many relationship between the CalendarTable and other two tables using the unique Date column under CalendarTable


    Hope this helps.

    Regards,
    Ketan !

ketan10's avatar
ketan10
Advocate III
9 years ago

Hi ruserty

 

You could  carry out the following steps:

1. Click on New Table under the Modeling tab
2.  Create a table name: CalendarTable = CALENDARAUTO(). This would give you a new unique date column in CalendarTable

3.  Go to the Relationships tab and create a one to many relationship between the CalendarTable and other two tables using the unique Date column under CalendarTable


Hope this helps.

Regards,
Ketan !

  • ruserty's avatar
    ruserty
    Regular Visitor
    9 years ago

    Real Deal! Thanks a lot!