Add Supervisor Column

[fjlorenzo]

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

[apathetichell]

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"

[Qiu · Accepted solution]

@fjlorenzo 
Agree with @apathetichell but the ID 00005 name is not there.

[fjlorenzo]

Hi @Qiu, thank you for your help.

[Qiu]

@fjlorenzo 
Glad to help and thank you for the accept mark 😁

[fjlorenzo]

Hi @apathetichell thank you.