Question

Join multiple tables with muliple columns

  • 13 May 2019
  • 1 reply
  • 1004 views

I wan to perform join in Model as shown in below diagram:




Can someone please guide me.


1 reply

Hi Komal,



If what you’re trying to do is join the tables in one explore, i believe it should look something like (not written in LookML by the way, just logically):



Explore: Users



join: Account


join on: Users.UserID = Account.UserID


relationship: one_to_one (assuming users only appear once in each table)



join: Signup


join on: Signup.SignUpID = Users.SignUpID


relationship: one_to_one (again assuming users only appear once in each table)



join: Login


join on: Login.LoginID = User.LoginID


relationship: one_to_one (using assumption users appear once in each table)



Hope that helps!

Reply