How Join with two explores?

dorch
Participant I

Hi

I built one explore :

a92961ba-2c2d-4657-bb02-8167c206b05e.png

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

e8846615-317e-4ec2-b26f-228c09a3988a.png
0 4 912
4 REPLIES 4

leobardor
Participant V

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

dorch
Participant I

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)

masutaka
Participant IV

@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

Top Labels in this Space
Top Solution Authors