Hi
I built one explore :
I want built customers explore and add these tables with left join to the explore but I don’t call views again, I want call to the order explore and do left join from customers to order explore.
I tries to used with extends parameter but I didn’t able
Hi Dorch!
There is an example in this looker article: https://help.looker.com/hc/en-us/articles/4420211311379-Dynamic-Joins-How-to-use-liquid-to-dynamical...
which uses “liquid” syntax to add a dynamic join. I think it will helps.
Best ,
Leo
Thanks for answer
but It isn’t help, it’s for SQL syntax . I want to join between two explore
I think you got next sql
select
**
from view_orders as view_orders
left join view_order_detail as order_detail on (orders.ID = order_detail.ID)
@dorchAre the two Explores the same Explore?
I don't know about that, but I have joined if two different Explore;
explore: user {
view_name: user
extends: [order]
join: order {
from: order
relationship: many_to_one
sql_on: -- join condition ;;
}
}
explore: order {
extension: required
join: order_ext {
relationship: many_to_one
sql: -- join condition ;;
}
}
view: user {
# ...
}
view: order {
# ...
}
view: order_ext {
# ...
}
This article may be helpful to you.
https://community.looker.com/lookml-5/using-extensions-to-define-joins-3679