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
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.