Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
hi @Anonymous
in your expected table, for row of 1100, why 1111 is there, but not 2222 and 3333?
Hello Its a created sample data. The rest of the rows would be pulled in similar way. I have updated the screenshot.
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |