Help with lookml/sql

[conor-flan]

I’m trying to create this SE name field in looker. It exists on the opportunity table/view. I want to bring in ‘Name’ from the user table when ‘se assigned’ = Id. 

It’s a simple vlookup in excel, but am not sure how to pull this into looker. HEre is the code I’m going with below

  dimension: se_name {
    type: string
    sql: SELECT FULL_NAME_C FROM "PROD_SALESFORCE" . "USER"  WHERE ${se_assigned} = ID   ;;
  }
 

[IanT]

You need to read up about sql joins and declare the join in lookml. Bit of reading for you: https://www.w3schools.com/sql/sql_join.asp

then once understood implement this in lookml: https://docs.looker.com/data-modeling/learning-lookml/working-with-joins