coalesce in view with two tables

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 

0 1 630
1 REPLY 1
Top Labels in this Space
Top Solution Authors