Hi everyone,
I have the below data and the first three columns are given. Only the Supervisor ID is given and I wanted to add the Supervisor Name. How can I add the Supervisor column to my table?
Name | Employee Number | Supervisor ID | Supervisor Name |
Abigail Lam | 00001 | 00003 | Allen Lorenzo |
Malou De Guzman | 00002 | 00003 | Allen Lorenzo |
Allen Lorenzo | 00003 | 00004 | Jonaly Adaya |
Jonalyn Adaya | 00004 | 00005 | Thess Dalmacio |
Thank you for your help.
-Florence Lorenzo
Solved! Go to Solution.
Self-Join - using join tool. (ie same table in both anchors.
table 1 - supervisor id table 2 - employee number. table 2 name becomes "supervisor name"
@fjlorenzo
Agree with @apathetichell but the ID 00005 name is not there.
Hi @Qiu, thank you for your help.
@fjlorenzo
Glad to help and thank you for the accept mark 😁
Hi @apathetichell thank you.