Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to extract names (Table1) from Id (Table2)

I have two tables one for student’s course information, another for Course Instructor Name. The two tables are joined by Course Instructor PIDM which is common key in both tables.

In Expected table (3rd Table I have the Course Instructor PIDM. I want to add the course instructor name on this table too -How can I get this?

 

 

Thanks in advance for your time and support. 

.DAX
@Dax help
DAX

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi Anonymous 

    in your expected table, for row of 1100, why 1111 is there, but not 2222 and 3333?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello Its a created sample data. The rest of the rows would be pulled in similar way. I have updated the screenshot.