MATCH between 2 tables !!!Please!!!

[ruserty]

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", custom "Conversion Rate"

In the 2nd table I have "Date", "Sessions", "Source/Medium",  "OperatingSystem", "City", "Country"

Please tell me how do I match those 2 tables to be able to filter the 1st one by values of 2nd one correctly? Or I need some other parameter in them?

Thank you!

[ketan10 · Accepted solution]

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]

Real Deal! Thanks a lot!

[MFelix]

Hi @ruserty,

You need to have a unique ID for each table and then add make a relationship between the two tables. I'm not used to treat Google Analytics information but you can probably use the combination of Date /  Sessions to make your Unique ID and then use it to make the connection between both tables.

Regards,

MFelix

[ruserty]

Thanks, I will try.