Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Merging tables/creating relationships

Hi All,   I'm hoping someone may be able to help me here...I have one table that has mutiple rows for each date which looks something like this:   Date                Channel          Goal 1 01/...
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Hi Anonymous

     

    Yes Chris, You can use Query Editor, Merge Queries and Left outer join to combine your tables. Please see the screenshot.

     

    Merge, Left Outer Join and Expand, Select Visits

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi Anonymous

 

Yes Chris, You can use Query Editor, Merge Queries and Left outer join to combine your tables. Please see the screenshot.

 

Merge, Left Outer Join and Expand, Select Visits

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks Bhavesh. If the goal columns are differnt in the two tables, so one is sign ups, the other is applications, could I merge by selecting just date and channel?

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    Yes You can.