Find Employees Manager Manager

JBerr
JBerr Member
in Magic ETL

Good Afternoon,

I have a dataset that has EE#, lastname, firstname, Manager, ManagerEE#, ect…, and my question is I need to find the employees Manager- Mananger; all of the employees are listed but there is no column for Manager's Manager.
How can I do that in an ETL to create a new column. Here is an example of how I want the data to look:

Employee Managers Manager.png


Thank you

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can join the dataset to itself so that the employee's manager field is joined to the employee field then you can rename the second manager field to manager of manager.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can join the dataset to itself so that the employee's manager field is joined to the employee field then you can rename the second manager field to manager of manager.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories