Forum Discussion
Adding Manager Phone from Employee table
Hey all,
I have a table containing an employee's name, their phone number, and their manager's name. Knowing that the manager's name and phone number are listed where they are listed as employees, I want to add a column containing manager phone numbers. What would be the easiest way to go about this?
Stay well all.
Hope that this will help. Generally, you need 2 tables, one containing just Employee/Mngr and Phone columns that you have. The second is containing Employee, Phone, Manager and you need to create new calculated column to lookup this phone next to the manager
5 Replies
Can you share some screenshot of your tables or sample data?
Here's some dummy data below. I've added in ManagerPhone, but that is what I am hoping to create, so it should look something like that. Taking the phone number from where the manager is listed as an employee and adding it to the columns where that employee is manager.
Employee Phone Manager ManagerPhone Greg 123 Clark 135 James 456 Bruce 246 Carol 789 Bruce 246 Clark 135 Diana 369 Bruce 246 Diana 369 Diana 369 Check this example:
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
