Hi!
I want to join explore A to explore B in my data model in lookml. Explore A was defined earlier in the model and has a lot of other joins inside it.
Is there a way to join these two with primary explore = B without defining again all the joins that were previously defined for explore A?
Thanks!
Solved! Go to Solution.
Hi @Carolina1 ,
You could try to use our extends feature. “This parameter allows you to build upon the content and settings from another Explore, using the other Explore as a starting point.”
If you have Explore A and Explore B, you could extend A into B or create a new Explore C, where you extend both A and B. You would just want to make sure the views are accessible based on joining the tables together in the new explore. Generally, the extended explore must be joined to the view that the base explore is based on.
Please let us know if you have any questions!
Thanks,
Eric
Hi @Carolina1 ,
You could try to use our extends feature. “This parameter allows you to build upon the content and settings from another Explore, using the other Explore as a starting point.”
If you have Explore A and Explore B, you could extend A into B or create a new Explore C, where you extend both A and B. You would just want to make sure the views are accessible based on joining the tables together in the new explore. Generally, the extended explore must be joined to the view that the base explore is based on.
Please let us know if you have any questions!
Thanks,
Eric
Hi Eric
I have same problem
https://community.looker.com/lookml-5/how-join-with-two-explores-31463?postid=60262#post60262can you give a example?