Join multiple tables with muliple columns

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!