Perform Merge on already existing explores (query IDs)

Knowledge Drop

Last Tested: Feb 7, 2020
 

Problem

Sometimes, we have a few explores already created and then realize that we want to merge them together. Thankfully, we can follow this hack and get the merge results quickly, without having to recreate the explores in the merge modal.

Solution

The below URL is the form you want.

https://[LOOKER_HOSTNAME]/merge?qids%5B%5D=[QID1]&qids%5B%5D=[QID2]

  1. Replace [LOOKER_HOSTNAME] with your base Looker URL, such as mycompany.looker.com
  2. Replace [QID1] with the first query you'd like to merge on.
  3. Replace [QID2] with the second query you'd like to merge on.

Got More Queries?

To add additional queries to the merge, continue the pattern. That is, add &qids%5B%5D=[QIDX] to the end of the URL.

The Automated Solution

So now we know that we can make a merged result by piecing together the merge URL manually using individual query IDs. But, is there a faster way to do this?

Yes! We can use @izzymiller’s Merge Monster: http://merge.monster/. Merge Monster is a tool that lets you save a bit of time by parsing the full explore URLs for each source query, and then generating a URL for the merged result. Note that this is a third-party tool (although it was made by a Looker) and it is not officially supported.

Version history
Last update:
‎04-05-2021 03:14 PM
Updated by: