I wan to perform join in Model as shown in below diagram:
Can someone please guide me.
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):
join on: Users.UserID = Account.UserID
relationship: one_to_one (assuming users only appear once in each table)
join on: Signup.SignUpID = Users.SignUpID
relationship: one_to_one (again assuming users only appear once in each table)
join on: Login.LoginID = User.LoginID
relationship: one_to_one (using assumption users appear once in each table)
Hope that helps!