Join multiple tables with muliple columns

(Komal Gawde) #1

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

Can someone please guide me.

0 Likes

(Adam Stott) #2

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!

2 Likes