Question

Extending multiple explores at the same time

  • 3 August 2021
  • 5 replies
  • 84 views

Userlevel 1

I haven’t been able to find an example of this? The documentation only seems to say it is possible, but doesn’t show any joins to explain it.


5 replies

Userlevel 1

I’m not sure it works.

Userlevel 1

Probably best to remove this from the documentation.

Userlevel 1

You can extend several explores, you will need to use a view_name parameter in your extended explore and a join. It will look like this:


Explore A {}


Explore B {}


Explore C {
extends: [A, B]
view_name: A
join: B {}
}

Hi Olga,

I have tried your method to extend explores and I get these errors:

>Unknown view "name_of_explore_a"

>Join name must match a view name, or the join must provide a 'from:'

Could you please give more details or documentation about this method?

Thanks a lot,

Bertrand

Userlevel 1

Sure, you can take a look at this documentation https://docs.looker.com/reference/explore-params/extends#example

 

The errors point us to the fact that the name of the explore (and the join)  you are using does not match the view which should be used for this explore and this join. 

In this case we should use additional syntax, like 

explore: explore_a_name {

extends: [explore a, explore b]

view_name: view_A_name

from: view_A_name

join: explore_b_name {

from: view_B_name

sql_on: ……. etc}

}

Reply