I have a requirement of doing a coalesce by joining two tables. I can do that in explore but as I need that to be used in multiple places I need to have it done in one view. I used the extends in a view but don't know how to join them in the view
Derived table is an option but checking if i can use lookml to do that