View the original community article here
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]
- Replace
[LOOKER_HOSTNAME]
with your base Looker URL, such asmycompany.looker.com
- Replace
[QID1]
with the first query you'd like to merge on. - 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