coalesce in view with two tables

[lijo-1651499852]

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 

[Dawid]

When you joined those two tables, have you tried creating a derived field just with:

sql: COALESCE(${main_table.field}, ${join_table.field}) ;;

This could live in either view file but would only work if the join exists in an explore.