Extends for Explores with multiple Joins

[Prapti]

Hi there!

I was looking for a way to merge two explores in my Looker Model. These two explores have multiple joins and fields that exist in the Views of one Explore do not necessarily exist in the View of another explore. While using extends to merge the second explore with the first one, Looker throws an error with the message “Inaccessible field xyz”. Is it not possible to extend an Explore if all of the fields defined in it are not present in the Explore that does the extending?

Thanks.

[thomas2]

Im having the same issue, extends don’t play nicely with joins.

[izzymiller]

This isn’t necessarily extends-specific, but any time you reference a view that in turn references another view, if view #2 isn’t joined in somehow, you’ll get that error.

The general practice is to use the fields: [] parameter to exclude the offending fields. Will that work?