Get Started Transforming Your Data in Snowflake

How to merge two Explores in Looker?

  • Looker FAQs
  • January 21, 2018

To merge two or more explores in Looker, we can use the Looker Merge functionality.

We will create a single query from Explore and then combine other queries with the first query. Here the first query is called the primary query, and the subsequent queries are joined using a Left Join.

Outlined below are the steps to create a merge between explores:

  1. After creating the Primary Query, click the gear icon in Explore and then Select Merge Result.
  2. On the next page, Looker will provide you an option to choose the Explore using which you would create a secondary query:
  3. Once you have created the secondary Look, click save, and you will land upon the Merged Results page.

  4. Review the dimensions that Looker used to match the queries.
  5. Click Run to see the merged query results.
  6. You will be able to save this merged tile on a dashboard by clicking on the gear menu.

Limitations of Looker Merge:

  • The merge occurs on the result set produced by each individual explore, not in the SQL query.
  • If any merged explore results in more than 5000 records, the row numbers greater than 5000 will be excluded from the merge. Thereby producing unexpected results.
  • Looker Tech support discourages using a merge due to its limitations.
  • Looker Merge is limited to Left Join. You cannot implement other joins like inner join or outer join between Explores.

Up Next:

Read How to enable the Google Sheets Action in Looker?

More Resources We Think You Might Like

How to create a funnel chart visualization in Looker?

How to add custom visualization in Looker using...

In Looker, there are two ways to add custom visualizations using Javascript: Adding a custom visu...

  • Looker FAQs
  • January 15, 2018
How to create a funnel chart visualization in Looker?

How to add image from my local drive (or locati...

We can use the HTML parameter in the LookML of the Dimension / Measure to have Looker render the ...

  • Looker FAQs
  • January 21, 2018
How to create a funnel chart visualization in Looker?

How to plot Latitude and Longitude from Google ...

This post shows how to use Google Sheets to get latitude or longitude and then map them into Look...

  • Looker FAQs
  • January 20, 2018