How Join with two explores?

Looker Q&A Looker
,
1

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

2

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-dynamically-adjust-sql-on-conditions-Community-

which uses “liquid” syntax to add a dynamic join. I think it will helps.

Best ,

Leo

3

Thanks for answer

but It isn’t help, it’s for SQL syntax . I want to join between two explore

4

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)

5

@dorch Are 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