Add a join to a preexisting view

I have a preexisting View, originated from a table in the datawarehouse, and I would like to add to this view a column from another table of the same schema.
Is it possible to perform this join on a preexisting View without having to transform it into a Derived Table?

0 3 679
3 REPLIES 3

You have your thinking wrong. Create another view for this new table in the schema and join the views together in the model file in an explore.

You have your thinking wrong. Create another view for this new table in the schema and join the views together in the model file in an explore.

Yes, i know this is the standard process, but i just need this one column from the second table and i didn't want to pollute the Explore with another View with just one dimension. So i'm looking for alternatives. 

In a join you can use fields: []-parameter in the join. That way you can join a single column, without polluting the explore with lots of irrelevant fields.

https://docs.looker.com/reference/explore-params/fields-for-join

Top Labels in this Space
Top Solution Authors